This data will work very well for a pivot table. To get started with pivot tables, have a look at http://peltiertech.com/Excel/Pivots/pivotstart.htm

cheers,