Pivot table creating isue regarding columns with the same name
 

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?

Pivot table creating isue regarding columns with the same name
 

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

wrote:
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
Contextures
http://www.contextures.com/tiptech.html