Pivot table creating isue regarding columns with the same name

[roberthammer]

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?

 

[Debra Dalgleish]

To get the pivot table setup that you want, use only one column for
instructor names. Then, create a separate row for each course for each
instructor. For example:

Course Hours Instructor
AAA 2 Name1
AAA 2 Name2