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