https://community.splunk.com/t5/Splunk-Search/How-to-pivot-convert-in-Splunk/m-p/606113#M210782 <LI-CODE lang="markup">| xyseries Fauf Station duration</LI-CODE> Tue, 19 Jul 2022 09:30:30 GMT ITWhisperer 2022-07-19T09:30:30Z https://community.splunk.com/t5/Splunk-Search/How-to-pivot-convert-in-Splunk/m-p/606105#M210778 <P>Hi,&nbsp;</P> <P>I habe a table after using stats:</P> <P>| stats values(durationSum) as duration by Fauf Station. How can I convert it to a table with only one line in such a format:</P> <P>Fauf duration_Station1 duration_Station2, duration_Station7, duration_Station10</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="zoe_0-1658220188640.png" style="width: 762px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/20578i828F6BEDD400F3CD/image-dimensions/762x80?v=v2" width="762" height="80" role="button" title="zoe_0-1658220188640.png" alt="zoe_0-1658220188640.png" /></span></P> <P>Thanks for helping in advance!</P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 19 Jul 2022 14:29:12 GMT https://community.splunk.com/t5/Splunk-Search/How-to-pivot-convert-in-Splunk/m-p/606105#M210778 zoe 2022-07-19T14:29:12Z https://community.splunk.com/t5/Splunk-Search/How-to-pivot-convert-in-Splunk/m-p/606113#M210782 <LI-CODE lang="markup">| xyseries Fauf Station duration</LI-CODE> Tue, 19 Jul 2022 09:30:30 GMT https://community.splunk.com/t5/Splunk-Search/How-to-pivot-convert-in-Splunk/m-p/606113#M210782 ITWhisperer 2022-07-19T09:30:30Z https://community.splunk.com/t5/Splunk-Search/How-to-pivot-convert-in-Splunk/m-p/606176#M210812 <P>Thank! it helps!</P> Tue, 19 Jul 2022 13:31:47 GMT https://community.splunk.com/t5/Splunk-Search/How-to-pivot-convert-in-Splunk/m-p/606176#M210812 zoe 2022-07-19T13:31:47Z