Here is my issue....I need to keep track of how many hours a certain
instructor will teach during the year.

This is based on the instructors last name (smith) and a field setup
for the course hours (i.e. 2). The problem i run into is the fact
that there are multiple instructors assigned to one course.

Basically the setup is this:

1st column (Course hours) | 2nd Column (instructor) | 3rd Column
(instructor) | 4rd Column (instructor)


When I try to make the pivot table, I want it to consolidate all of
the instructor names on the left side, with the total number of hours
as the data section.

Any help?