title: Matrix Transpose TSQL
body: <p>Can we do matrix transpose (rows become columns and columns become rows) in standard SQL2005/2008? </p>
  
  <pre>
  1 2 3 4 5
  4 5 6 6 7
  7 8 9 8 9
  1 3 4 5 6
  2 4 5 6 7</pre>
  
  <p>changes to </p>
  
  <pre>1 4 7 1 2
  2 5 8 3 4 
  3 6 9 5 6
  4 6 8 5 6
  5 7 9 6 7 </pre>
  
  <p>how about no of rows &lt;&gt; no of column ? </p>
  
  <p>let's consider the no of rows it's fixed. </p>