title: Summarize data in Excel with VBA
body: <p>I have a table in Excel with dates and values. Every day there were a number of different values.</p>
  
  <p>I want to summarize how many of each value there were every day.</p>
  
  <p>Example:
  From this</p>
  
  <pre><code>Date  Value
  
  10/1  Blue
  10/1  Blue
  10/1  Red
  11/1  Blue
  11/1  Blue
  </code></pre>
  
  <p>I want to get a new table with something like this:</p>
  
  <pre><code>     10/1    11/1
  Blue    2       2
  Red     1       0
  </code></pre>
  
  <p>I'm convinced this is possible to do in VBA/Excel. Does anyone have any ideas?</p>