use a pivot table!

Post your data, I'll talk you through how