Using Pivot Tables to Clean Up Presentation of Alpha Data

[rjbinney]

I suspect Access may be better tooled for this, but every time I struggle over something, someone says, "Why didn't you do a Pivot Table", and in like seven seconds they amaze me...

Anyway:

I have a huge table of employees. Columns of Data:

• Name
• Title
• Specialty
• Comment
• Division
• Division Manager

I'd like to print out something like:

Western Division, Joe Manager
Joe Employee, Project Manager Electrical
Joe Supervisor, Project Supervisor Mechanical
Jan Thebeancounter, Accountant

Eastern Division, Joe Superintendent
Mary Contrary, Counsel Construction
Jack Employee, Senior Engineer
etc.

(In other words, for each division:
Division, Division Manager
List of: Names, Position Specialty



So far I've only been able to get:

[Filter by Division]
Joe Employee
Project Manager
Electrical
Joe Supervisor
Project Supervisor
Mechanical
Jan Thebeancounter
Accounting
(blank)

In other words, it's indented instead of columnar, it prints "(blank)" instead of leaving it blank, I have to manually crank each division, and it doesn't list division's supervisor.

Is pivoting the right tool here, or should I be playing Access.

Thanks!

rjb