title: SQL query to transpose rows to columns in MS Access table
body: <p>I have the following MS Access 2010 table (No,F1 F2 are the headers):</p>
  
  <pre><code>No F1  F2
  1  a1  b1
  2  a1  b2
  3  a3  b3
  4  a4  b4
  5  a5  b5
  6  a6  b6
  </code></pre>
  
  <p>I need an SQL query to perform a transpose columns to rows operation in order to obtain the following output:</p>
  
  <pre><code>1   2    3   4   5   6
  a1  a2  a3  a4  a5  a6
  b1  b2  b3  b4  b5  b6
  </code></pre>
  
  <p>Thank you, 
  M.R.  </p>