title: Transpose rows to columns in splunk search
body: <p>I have a table from a search query which has 5 rows and 1 column (known as host_type). I want to transpose the table in such a way so that I get 5 columns and 1 row. Any help will be appreciated.</p>
  
  <p>This is the query I am using:</p>
  
  <pre><code>host_type=* sourcetype=* index=* xyz | fields host_type
  </code></pre>