You might need to post a sample Excel file that shows your data structure so we can suggest a way to produce a report like this.

I suspect that this is not something that is suited to a Mail Merge report in Word. It does however look like something you could do in Excel with a Pivot Table or possibly in Microsoft Access with a SQL query and report based on that query. It will be important to see how your data is tabulated to work out a method of producing this report.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia