Excel/Mail Merge

Hello

I run a virtual learning environment. Each course in this environment has a role that allows some users to edit the course area. This means they place content in there. I would like to be able to send the tutors reports on the usage in the course area. I have created a query that gives me a massive spreadsheet with each tutor identity and a link to each course where they can access a report of usage.

The problem is many of the tutors can edit across many courses. This means that there is a row per tutor per course.

tutor1, course1
tutor1, course2 etc

If i use this data for an email merge, I will end up with one email per course, which will mean multiple emails and general annoyance.

I would like to reformat that data so I can get a single record for each tutor that gives a list of the reports they can access like this:

tutor1, course1, course2,course3 etc.
tutor2, course1, course2,course3 etc.

Any help you can give with this would be very appreciated.

Tina