title: Transpose groups of data in Excel or Access
body: <p>I have a <strong>large</strong> group of data that looks like:</p>
  
  <pre><code>M.   Item   Num 
  A     a      3 
  A     b      2
  A     c      1
  B     a      4
  B     b      2
  B     c      3
  B     d      1
  C     a      1
  C     b      2
  </code></pre>
  
  <p>I need to transform them into format like:</p>
  
  <pre><code>M.   Item    Num   Item    Num   Item    Num   Item    Num 
  A     a       3      b      2      c      1
  B     a       4      b      2      c      3      d      1
  C     a       1      b      2
  </code></pre>