title: How to Transpose the data in Pivot table?
body: <p>I have a source content as shown below</p>
  
  <pre><code>Name    Age Month   Maths   Science Physics
  John    21   1        80     88      76
  John    21   2        89     99      78
  John    21   3        76     76      89
  John    21   4        78     78      90
  John    21   5        88     89      96
  Sara    22   1        76     76      89
  Sara    22   2        78     78      90
  Sara    22   3        88     89      96
  Sara    22   4        76     76      89
  Sara    22   5        78     78      90
  </code></pre>
  
  <p>and i am looking to create a pivot table in excel something like this.</p>
  
  <pre><code>Name    John
  Age     All                 
  
  Month               1   2   3   4   5
  Maths               80  89  76  78  88
  Science             88  99  76  78  89
  Physics             76  78  89  90  96
  </code></pre>
  
  <p>Is this possible? Thanks for looking</p>