How to sort first column data by using the rest of column value?

[Purplefeet]

Sorry I am not sure if I describe my question accurate enough in the title, but what I want is like below:

For example: I have below table

[TABLE="width: 500"]
<tbody>[TR]
[TD]Team NW[/TD]
[TD]F7.1[/TD]
[TD]F5.2[/TD]
[TD]F8.1[/TD]
[TD]F3.2.2[/TD]
[/TR]
[TR]
[TD]Team Head[/TD]
[TD]F5.2[/TD]
[TD]F5.2.3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Team Center[/TD]
[TD]F8.1[/TD]
[TD]F5.2[/TD]
[TD]F5.2.3[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


2. I like to have table like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]F7.1[/TD]
[TD]F5.2[/TD]
[TD]F8.1[/TD]
[TD]F3.2.2[/TD]
[TD]F5.2.3[/TD]
[/TR]
[TR]
[TD]Team NW[/TD]
[TD]Team NW[/TD]
[TD]Team NW[/TD]
[TD]Team NW[/TD]
[TD]Team Head[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Team Head[/TD]
[TD]Team Center[/TD]
[TD][/TD]
[TD]Team Center[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Team Center[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

or

[TABLE="width: 500"]
<tbody></tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]F7.1[/TD]
[TD]Team NW[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F5.2[/TD]
[TD]Team NW[/TD]
[TD]Team Head[/TD]
[TD]Team Center[/TD]
[/TR]
[TR]
[TD]F8.1[/TD]
[TD]Team NW[/TD]
[TD]Team Center[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F3.2.2[/TD]
[TD]Team NW[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F5.2.3[/TD]
[TD]Team Head[/TD]
[TD]Team Head[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I am guessing the PivotTable feature may help to make it easier to happen, but not sure how to do it. The table I am working on is more complicated that above examples, it is 50 rows with 37 columns, therefore, I like to find a easy way to sort it out. Thank you for your help!