Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
pivot table data 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Surpressing rows and columns with zero values in a pivot table 1

Back
Top