https://community.splunk.com/t5/Splunk-Search/How-to-change-the-output-format-of-search-results/m-p/224560#M66172 <P>I assume your query looks like this (you may have list, instead of values)</P> <PRE><CODE>base search | stats values(y) as y by x </CODE></PRE> <P>change this to...</P> <PRE><CODE>base search | stats values(y) as y by x | mvexpand y </CODE></PRE> Mon, 15 Aug 2016 02:07:12 GMT sundareshr 2016-08-15T02:07:12Z https://community.splunk.com/t5/Splunk-Search/How-to-change-the-output-format-of-search-results/m-p/224559#M66171 <P>Using my splunk query, I am getting the output as follows (X and Y are headers)- </P> <PRE><CODE>X Y ----------- 1 A B C 2 A B C 3 A B C 4 A B C </CODE></PRE> <P>But I need the output in the below format - </P> <PRE><CODE>X Y ----------- 1 A 1 B 1 C 2 A 2 B 2 C 3 A 3 B 3 C 4 A 4 B 4 C </CODE></PRE> <P>I tried using stats, list, and other formatting commands but it didn't work for me.<BR /> Can I get any help? Thanks in advance....</P> Mon, 15 Aug 2016 01:28:53 GMT https://community.splunk.com/t5/Splunk-Search/How-to-change-the-output-format-of-search-results/m-p/224559#M66171 gadeanup1 2016-08-15T01:28:53Z https://community.splunk.com/t5/Splunk-Search/How-to-change-the-output-format-of-search-results/m-p/224560#M66172 <P>I assume your query looks like this (you may have list, instead of values)</P> <PRE><CODE>base search | stats values(y) as y by x </CODE></PRE> <P>change this to...</P> <PRE><CODE>base search | stats values(y) as y by x | mvexpand y </CODE></PRE> Mon, 15 Aug 2016 02:07:12 GMT https://community.splunk.com/t5/Splunk-Search/How-to-change-the-output-format-of-search-results/m-p/224560#M66172 sundareshr 2016-08-15T02:07:12Z https://community.splunk.com/t5/Splunk-Search/How-to-change-the-output-format-of-search-results/m-p/224561#M66173 <P>Good learnings, Sundaresh Sir.</P> Mon, 15 Aug 2016 05:41:45 GMT https://community.splunk.com/t5/Splunk-Search/How-to-change-the-output-format-of-search-results/m-p/224561#M66173 inventsekar 2016-08-15T05:41:45Z