Try using a pivot table, that should do it.

Stu