title: Excel Pivot Table - Formatting and Grouping Columns with Dates and Another Column
body: <p>I have worked with basic pivot tables for a few years, however I am getting stuck on something that I think should be fairly simple to solve (ugh). </p>
  
  <p>I would like to format my pivot table in a specific way.</p>
  
  <p>For example, just say I am using the following data:</p>
  
  <pre><code>Client Name Stage   Amount Paid  Date Paid
  Client A    Start    $70,000     1/10/2015
  Client A    Middle   $50,000     1/11/2015
  Client A    End      $30,000     1/12/2015
  Client B    Start    $50,000     5/11/2015
  Client B    Middle   $30,000     5/11/2015
  Client B    End      $50,000     5/12/2015
  Client C    Start    $10,000     10/12/2015
  Client C    Middle   $20,000     20/12/2015
  Client C    End      $30,000     30/12/2015
  </code></pre>
  
  <p>I would like to arrange the pivot table so that it looks like this:</p>
  
  <p><a href="http://i.stack.imgur.com/qiGGa.png" rel="nofollow">Table Example with Correct Formatting</a></p>
  
  <p>The only way I can almost get it to work is if it looks like this:</p>
  
  <p><a href="http://i.stack.imgur.com/cg1c5.png" rel="nofollow">PivotTable Example - Not correct formatting</a></p>
  
  <p>I really need the formatting to be exactly like picture one.</p>
  
  <p>Thanks for any help you may be able to provide. </p>
  
  <p>Answers in excel steps or in VBA code would be awesome :)</p>