I've got a list of transaction dates and the user id of the person who made the transaction on that date (just 1 Tx/day allowed). For example:

![](https://farm5.static.flickr.com/4045/4282685403_9d4412878c_o.png)

I'd like to create a matrix which shows, as of each date, the number of users who have made 1 transaction, 2-10 transactions, 10-20 transactions, etc. For example (note, the below data doesn't correspond to the transaction data above):

![](https://farm5.static.flickr.com/4007/4282685425_aa3f85b625_o.png)

Is a pivot table my best mechanism here? If so (or not) how would I approach this?