Help with comparison chart / pivot table

[coreytrillo]

Hi all,

This is driving me crazy. Using Excel 2003.

- I have a list of students that have completed some training courses and I am trying to put together a pivot table or comparison sheet that shows which which classes are "completed" and which classes are still "required".

- The data that I have is four (4) columns -
"Lastname" "Firstname" "Name of Class Completed" "Name of Class Required"

Thanks in advance!

Corey

[teylyn]

Hello, can you please upload a data sample in an Excel workbook and explain what you would like to see as the result of the pivot table?

[coreytrillo]

Thank you for the response. I have uploaded a sample as an attachment.

Basically, the part in pink is the data that I have to work with.

The Pivot Table on the left is what I have been able to accomplish.

I want to be able to add the data that is in red to the pivot table as a seperate column so that I can see which courses the students have not taken.

I hope this makes sense, its kind of hard to articulate.

Thanks again!
Corey

[teylyn]

Hello,

You'd have to re-arrange your source data to create a pivot table with all courses. Include all courses per name, then use a column to indicate if they have been completed or not. See attached

cheers