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
--
Regards

Roger Govier


"Valery2105" wrote in message
...
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