I have a table in Excel with dates and values. Every day there were a number of different values.

I want to summarize how many of each value there were every day.

Example:
From this

```
Date  Value

10/1  Blue
10/1  Blue
10/1  Red
11/1  Blue
11/1  Blue

```

I want to get a new table with something like this:

```
     10/1    11/1
Blue    2       2
Red     1       0

```

I'm convinced this is possible to do in VBA/Excel. Does anyone have any ideas?