title: Transposing or Pivoting in Access 2016
body: <p>I would like to know how to Transpose or Pivot a table with Customer Number, Month and Quantity so that I could be easily understood in Access 2016. I am used queries as I find them easier. So it would be of great help if anyone could help me with the function or procedure to attain the solution.</p>
  
  <p>To clarify, I would like to change the below table with only two rows having the CustomerNo. 11 and 12 so that quantities are listed under each month.</p>
  
  <pre><code>CustomerNo.| Quantity | Month
  ==============================
  11         | 22       | Jan 18
  11         | 20       | Feb 18
  11         | 18       | Mar 18
  12         | 10       | Jan 18
  12         | 8        | Feb 18
  12         | 15       | Mar 18
  </code></pre>
  
  <p>Expected Output:</p>
  
  <pre><code>                |Jan 18 | Feb 18 | Mar 18 
     Customer No. |       |        |
   ==========================================
      11        |  22     |  20    |  18
      12        |  10     |  8     | 15
  </code></pre>
  
  <p>Thanks ! </p>