title: How do I transpose this Excel pivot worksheet data?
body: <p>I have a set of data in this format:</p>
  
  <pre>Column1 column2 column3 22/8  23/8  24/8 25/8 26/8
  A       B         C      2       3    4    5   6
  D       E         F      5       6    7    7   7</pre>
  
  <p>I need to transpose it to this format:</p>
  
  <pre>
  A   B   C  22/8    2
  A   B   C  23/8    3
  A   B   C  24/4    4
  A   B   C  25/8    5
  A   B   C  26/8    6
  D   E   F  22/8    5</pre>
  
  <p>Is it possible in Excel/Access without copying and paste special to transpose format?</p>