Pivot Table

V

Valery2105

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

Dealing with a Pivot Table (when I don't want to) 0
Need some PWA help 0
Doughnut Chart linked with the slicer in the pivot table 0
Ungrouping the fields inside pivot table(Excel 2007) 1
Transpose large data from columns to rows 3
Compute Additional Hours Needed Using "if" or "lookup" 1
Rank items in Pivot Table 3
Pivot table 0

Top