topic Re: How to transpose a table to make the values in Column 1 the header labels? in Splunk Search https://community.splunk.com/t5/Splunk-Search/How-to-transpose-a-table-to-make-the-values-in-Column-1-the/m-p/244294#M72732 <P>Try this:</P> <PRE><CODE>yoursearch | transpose header_field=a | fields - column </CODE></PRE> Thu, 21 Jan 2016 10:12:13 GMT javiergn 2016-01-21T10:12:13Z How to transpose a table to make the values in Column 1 the header labels? https://community.splunk.com/t5/Splunk-Search/How-to-transpose-a-table-to-make-the-values-in-Column-1-the/m-p/244293#M72731 <P>orange table:</P> <PRE><CODE> a b -------- fld1 1 fld2 2 fld3 3 fld4 4 </CODE></PRE> <P>I want to change it to:</P> <PRE><CODE> fld1 fld2 fld3 fld4 -------------------------------- 1 2 3 4 </CODE></PRE> <P>Where 'fldx' are the header labels</P> <P>However, using the <CODE>transpose</CODE> command results in:</P> <PRE><CODE> row1 row2 row3 row4 ---------------------------------- fld1 fld2 fld3 fld4 1 2 3 4 </CODE></PRE> <P>How do I get the desired result?</P> Thu, 21 Jan 2016 10:01:28 GMT https://community.splunk.com/t5/Splunk-Search/How-to-transpose-a-table-to-make-the-values-in-Column-1-the/m-p/244293#M72731 crazyeva 2016-01-21T10:01:28Z Re: How to transpose a table to make the values in Column 1 the header labels? https://community.splunk.com/t5/Splunk-Search/How-to-transpose-a-table-to-make-the-values-in-Column-1-the/m-p/244294#M72732 <P>Try this:</P> <PRE><CODE>yoursearch | transpose header_field=a | fields - column </CODE></PRE> Thu, 21 Jan 2016 10:12:13 GMT https://community.splunk.com/t5/Splunk-Search/How-to-transpose-a-table-to-make-the-values-in-Column-1-the/m-p/244294#M72732 javiergn 2016-01-21T10:12:13Z Re: How to transpose a table to make the values in Column 1 the header labels? https://community.splunk.com/t5/Splunk-Search/How-to-transpose-a-table-to-make-the-values-in-Column-1-the/m-p/244295#M72733 <P>awesome cool !<BR /> thank you very much !<BR /> I did not find 'header_field' argument in Search Reference v6.2.3. I need update it.<BR /> by the way I find a solution using <CODE>xyseries</CODE> command. but it's not so convenient as yours<BR /> Edit:<BR /> <CODE>transpose</CODE>'s width up to only 1000<BR /> <CODE>xyseries</CODE> seams will breake the limitation<BR /> <CODE>|eval tmp="anything"|xyseries tmp a b|fields - tmp</CODE></P> Thu, 21 Jan 2016 10:25:57 GMT https://community.splunk.com/t5/Splunk-Search/How-to-transpose-a-table-to-make-the-values-in-Column-1-the/m-p/244295#M72733 crazyeva 2016-01-21T10:25:57Z Re: How to transpose a table to make the values in Column 1 the header labels? https://community.splunk.com/t5/Splunk-Search/How-to-transpose-a-table-to-make-the-values-in-Column-1-the/m-p/244296#M72734 <P>Good job! Actually also in my case "xysersies" works better!</P> Tue, 15 Mar 2016 14:01:41 GMT https://community.splunk.com/t5/Splunk-Search/How-to-transpose-a-table-to-make-the-values-in-Column-1-the/m-p/244296#M72734 marcoscala 2016-03-15T14:01:41Z Re: How to transpose a table to make the values in Column 1 the header labels? https://community.splunk.com/t5/Splunk-Search/How-to-transpose-a-table-to-make-the-values-in-Column-1-the/m-p/244297#M72735 <P>Hi, <BR /> Thank You Very much. "transpose header_field=a" worked. </P> Thu, 13 Oct 2016 06:23:11 GMT https://community.splunk.com/t5/Splunk-Search/How-to-transpose-a-table-to-make-the-values-in-Column-1-the/m-p/244297#M72735 purnavenkatesh 2016-10-13T06:23:11Z Re: How to transpose a table to make the values in Column 1 the header labels? https://community.splunk.com/t5/Splunk-Search/How-to-transpose-a-table-to-make-the-values-in-Column-1-the/m-p/244298#M72736 <P>Hi,<BR /> transpose header_field=count doesn't work for me. Please help</P> Mon, 25 Jun 2018 19:03:38 GMT https://community.splunk.com/t5/Splunk-Search/How-to-transpose-a-table-to-make-the-values-in-Column-1-the/m-p/244298#M72736 snayani 2018-06-25T19:03:38Z Re: How to transpose a table to make the values in Column 1 the header labels? https://community.splunk.com/t5/Splunk-Search/How-to-transpose-a-table-to-make-the-values-in-Column-1-the/m-p/244299#M72737 <P>Hi, can you post here your search and give us more details about your data?</P> Tue, 26 Jun 2018 07:18:25 GMT https://community.splunk.com/t5/Splunk-Search/How-to-transpose-a-table-to-make-the-values-in-Column-1-the/m-p/244299#M72737 javiergn 2018-06-26T07:18:25Z Re: How to transpose a table to make the values in Column 1 the header labels? https://community.splunk.com/t5/Splunk-Search/How-to-transpose-a-table-to-make-the-values-in-Column-1-the/m-p/244300#M72738 <P>Hi, I tried this way and it worked: <BR /> search string ...... | transpose 5 <BR /> | rename column as "Database Error Type", "row 1" as "Count"</P> Tue, 26 Jun 2018 12:15:27 GMT https://community.splunk.com/t5/Splunk-Search/How-to-transpose-a-table-to-make-the-values-in-Column-1-the/m-p/244300#M72738 snayani 2018-06-26T12:15:27Z Re: How to transpose a table to make the values in Column 1 the header labels? https://community.splunk.com/t5/Splunk-Search/How-to-transpose-a-table-to-make-the-values-in-Column-1-the/m-p/244301#M72739 <P>OK I have been looking for an answer like this for days!!! Thank you! </P> Fri, 10 Aug 2018 19:36:02 GMT https://community.splunk.com/t5/Splunk-Search/How-to-transpose-a-table-to-make-the-values-in-Column-1-the/m-p/244301#M72739 jimwilsonssf 2018-08-10T19:36:02Z