Access/Excel question--generating separate sheets with info for different courses

Factual Questions
1

Say I’ve got an excel spreadsheet that looks like this:



Name    |Course
A       |1
B       |3
C       |3
A       |2
C       |2

i.e. different students (who I’m calling A, B and C) associated with different courses (which I’m number 1, 2 and 3).

What I would like to accomplish is to generate a separate document for each course, listing just which students are associated with that course.

The actual list is much longer than the above of course.

Mail merge using Word with Excel doesn’t quite seem to do the trick–since it will generate a separate document for each row. I just want a separate document for each course.

Excel methods for this are escaping me (probably because I don’t know that much about Excel). I suspect this is something Access can do, but know even less about Access.

Is there any hope for this?

2

One simple way is to use pivot tables (the answer to surprisingly many questions). Create a pivot table using “Course” as the first row label and “Name” as the second. This will produce a pivot table showing each course with the list of names associated with it.

If you want each course on a separate worksheet, copy this pivot table into enough sheets to cover the number of courses you have, then in each, filter the course to show just the one you want.

3

Thanks, I made that work.

4

If you simply want to print each course separately, you can do it with a single pivot table. In the pivot table designer, edit the Field Properties for the Course field and check the box for “Insert page break after each item” on the Layout & Print tab.