title: SQL - Column to Row conversion in Report
body: <p>I have a table with student-name and student-city only. This table is used to find out which student has enrolled online-course from which city.</p>
  
  <p>Table - StudentCity</p>
  
  <pre><code>Name               City
  
  Anand              Mumbai
  
  Vinod              Mumbai
  
  Shailesh           Pune
  
  Rupali             Delhi
  
  Annavi             Pune
  
  Arunabha           Kolkata
  </code></pre>
  
  <p>I need the report in the following format:</p>
  
  <pre><code>Mumbai    Pune      Delhi   Kolkata
  
  Anand   
  
  Vinod
            Shailesh
                      Rupali
            Annavi
                              Arunabha
  </code></pre>
  
  <p>I am trying to find out a way so that I can use recursive SQL for this. But till now have not succeeded.</p>
  
  <p>Can someone help me out on this.</p>