title: convert Column values into Row values
body: <p>i have a table like below</p>
  
  <pre><code>   structure_no  |   element_name
          1        |      BASIC
          1        |      HRA
          2        |      BASIC
          2        |      HRA
  </code></pre>
  
  <p>I would like to get the values </p>
  
  <pre><code>   structure_no    |  element1   | element2
          1          |  BASIC      |   HRA 
          2          |  BASIC      |   HRA 
  </code></pre>
  
  <p>Kindly help me in forming SQL Query</p>