Pivot trouble

[rugbytomc]

wasn't sure what to title this.

If i have data as such

[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Score[/TD]
[/TR]
[TR]
[TD]Ian[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Ian[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Ian[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Ian[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

What I want to see is this
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Score 1[/TD]
[TD]Score 2[/TD]
[TD]Score 3[/TD]
[TD]Score 4[/TD]
[TD]Score 5[/TD]
[/TR]
[TR]
[TD]Ian[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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.

[TABLE="width: 327"]
<tbody>[TR]
[TD]Row Labels[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD]Grand Total[/TD]
[/TR]
[TR]
[TD]Ian[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]21[/TD]
[/TR]
</tbody><colgroup><col><col><col span="3"><col></colgroup>[/TABLE]