title: sql select query convert 1st column as header and second column as row?
body: <p>Is it possible to convert 1st column  as header and second column as row? Please find a example below</p>
  
  <pre><code>   Type  | qty  (Header)
    Apple    4
    Orange   10
    Grapes   5
  
  
  Apple | Orange | Grapes (Header)
  4       10         5       
  </code></pre>