Pivot Table

G

Guest

Hi! Hope someone can help,

I am trying to create a Pivot Table from a spreadsheet as below:

Employee Training Title - 1 2 3 4 5 6
Ben Y Y
Joe Y
Ken Y

Basically I have a problem creating this Pivot Table as I cannot get it to
List the Training Title that runs accross the first column, and if and how
many courses the Employee has attended.

Is this possible?
Thanks
 
R

Roger Govier

Hi Valery

If I understand you correctly, your data is not set out in a suitable
way for PT analysis.
What you need is

Name Course Attended
Ben 1 Y
Joe 2 Y
Ken 3 Y
Ben 4 Y

Then create your PT dragging Name to Row area, Course to Column area and
Count of Attended to Data area
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ungrouping the fields inside pivot table(Excel 2007) 1
Rank items in Pivot Table 3
Transpose large data from columns to rows 3
Pivot Table / Pivot Chart 3
Pivot Table with Where clause? 8
Question on the occupied field of the pivot table in excel spreadsheet 0
How to create a calculated field formula based on Pivot Table resu 1
Copying values from pivot table to cells outside pivot table 4

Top