Pivot trouble

[rugbytomc]

wasn't sure what to title this.

If i have data as such

Name	Score
Ian	1
Ian	2
Ian	3
Ian	4
James	1
James	2
James	3
James	4
John	1

<tbody>
</tbody>

What I want to see is this

Name	Score 1	Score 2	Score 3	Score 4	Score 5
Ian	1	2	3	4
James	1	2	3	4	5
John	1

<tbody>
</tbody>

Any suggestions on how best to do that?

Thanks

 

[slpswhite]

Create a Pivot table and use the names as Row Labels and use Score as both Column Labels and Values. It should give you what you want.

Row Labels	1	2	3	4	Grand Total
Ian	1	2	3	4	10
James	1	2	3	4	10
John	1				1
Grand Total	3	4	6	8	21

<tbody>
</tbody><colgroup><col><col><col span="3"><col></colgroup>