Pivot Table Where Data Has No Column Header

[SteveP29]

Hi,
Is there a pivot table that can be created from 'transposed' data?

The pivot table I'm trying to create is intended to tell me the winner of a golf skin and how many skins they won in doing so.
My raw data is arranged with player names in column A, hole scores in columns B-S and a total score in column T.

Below this table, I have a summary that shows who won the skin on one row and how many skins that win was worth, see example below

Winner	JD	DC	n/a	JD	etc to hole 18
Skins Won	1	1		2

Is there a way to create a pivot table from this data to summarise who won how many skins?

 

[SteveP29]

Hi,
Is there a pivot table that can be created from 'transposed' data?

The pivot table I'm trying to create is intended to tell me the winner of a golf skin and how many skins they won in doing so.
My raw data is arranged with player names in column A, hole scores in columns B-S and a total score in column T.

Below this table, I have a summary that shows who won the skin on one row and how many skins that win was worth, see example below

Winner	JD	DC	n/a	JD	etc to hole 18
Skins Won	1	1		2

Is there a way to create a pivot table from this data to summarise who won how many skins?

The pivot table I'm trying to create would look like this based on the data in my example above:

Player	Skins
JD	3
DC	1

Apologies for the inability to format and tidy up the example tables

 

[shift-del]

Hello Steve

To use a pivot table your data needs to be in form of a record set list.
Player - Hole - Skins won