title: Excel pivot table - grouping data and multiple data series
body: <p>I have Excel data similar to the following:</p>
  
  <pre><code>Category | 2008 | 2009 | 2010 |
  Apples   | 100  | 150  | 200  |
  Apples   | 300  | 100  | 400  |
  Oranges  | 500  | 500  | 600  |
  </code></pre>
  
  <p>I'd like to group the data together.  I can write a macro to do this, but wondered if I can do this with an Excel feature such as pivot tables, before I code this.</p>
  
  <p>The output would then be the following:</p>
  
  <pre><code>Category | 2008 | 2009 | 2010 |
  Apples   | 400  | 250  | 600  |
  Oranges  | 500  | 500  | 600  |
  </code></pre>
  
  <p>I realise stack overflow isn't exactly the right kind of place for this question these days, but couldn't find a more appropriate SE site to ask it in.</p>