https://community.splunk.com/t5/Splunk-Search/How-to-get-Field-values-as-column-names-headers-in-the-table/m-p/558151#M158527 <LI-CODE lang="markup">| transpose 0 header_field=NETYPE | fields - column</LI-CODE> Fri, 02 Jul 2021 12:03:56 GMT ITWhisperer 2021-07-02T12:03:56Z https://community.splunk.com/t5/Splunk-Search/How-to-get-Field-values-as-column-names-headers-in-the-table/m-p/558148#M158526 <P>Hi Team,</P><P>I have a simple requirement but unable to get it. I am using a query</P><P>index=tms sourcetype=kafka type=ssh| stats count by NETYPE</P><P>For above query I am getting output as below</P><TABLE border="1" width="100%"><TBODY><TR><TD width="50%" height="25px">NETYPE</TD><TD width="50%" height="25px">Count</TD></TR><TR><TD width="50%" height="25px">CISCO</TD><TD width="50%" height="25px">100</TD></TR><TR><TD height="25px">JUNIPER</TD><TD height="25px">200</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>However, I want output as</P><TABLE border="1" width="100%"><TBODY><TR><TD width="50%">CISCO</TD><TD width="50%">JUNIPER</TD></TR><TR><TD width="50%">100</TD><TD width="50%">200</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Can you please help how can I get above o/p table</P> Fri, 02 Jul 2021 11:21:56 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-Field-values-as-column-names-headers-in-the-table/m-p/558148#M158526 poddura 2021-07-02T11:21:56Z https://community.splunk.com/t5/Splunk-Search/How-to-get-Field-values-as-column-names-headers-in-the-table/m-p/558151#M158527 <LI-CODE lang="markup">| transpose 0 header_field=NETYPE | fields - column</LI-CODE> Fri, 02 Jul 2021 12:03:56 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-Field-values-as-column-names-headers-in-the-table/m-p/558151#M158527 ITWhisperer 2021-07-02T12:03:56Z