title: Simple way to transpose columns and rows in SQL?
body: <p>How do I simply switch columns with rows in SQL?
  Is there any simple command to transpose?</p>
  
  <p>ie turn this result:</p>
  
  <pre><code>        Paul  | John  | Tim  |  Eric
  Red     1       5       1       3
  Green   8       4       3       5
  Blue    2       2       9       1
  </code></pre>
  
  <p>into this:</p>
  
  <pre><code>        Red  | Green | Blue
  Paul    1       8       2
  John    5       4       2
  Tim     1       3       9
  Eric    3       5       1
  </code></pre>
  
  <p><code>PIVOT</code> seems too complex for this scenario.</p>