How to combine columns for a pivot table

B

Bob

I have a spreadsheet set up as follows:

Date Level Instructor1 Instructor2 Instructor3
8/31/03 A Tom Eric
9/1/03 A Tom Steve
9/1/03 B Fred Mary
9/1/03 C Jeff Eric
9/2/03 A Tom Fred Mary

I need to get a summary per instructor that shows how many of each level
they taught along with a total. The problem is that the insructors are in
three separate fields.
A B C Total
---- ---- --- -----
Eric 1 1 2
Fred 1 1 2
Jeff 1 1
Mary 1 1 2
Steve 1 1
Tom 3 3

This should probably be a database but a pivot table would be an easier
solution for the user since the whole spreadsheet is already set up.

Thanks,
Bob
rhw at lucent dot com
 
Top