title: Transposing Rows in to colums in SQL Server 2005
body: <p>I have an sql query "Select * from tablename" whose output is </p>
  
  <pre><code>col1   col2       
    A     1 
    B     2 
    C     3
  </code></pre>
  
  <p>I want to modify the above output to below as following</p>
  
  <pre><code>A      B      C
  1      2      3 
  </code></pre>
  
  <p>Please let me know how could I achieve this</p>