From my understanding of your situation, I think you are looking at using a pivot table. This will allow you to summarise large quantities of data and actually group them.