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

Team NW	F7.1	F5.2	F8.1	F3.2.2
Team Head	F5.2	F5.2.3
Team Center	F8.1	F5.2	F5.2.3

<tbody>
</tbody>

2. I like to have table like this:

F7.1	F5.2	F8.1	F3.2.2	F5.2.3
Team NW	Team NW	Team NW	Team NW	Team Head
	Team Head	Team Center		Team Center
	Team Center

<tbody>
</tbody>

or

<tbody></tbody>

F7.1	Team NW
F5.2	Team NW	Team Head	Team Center
F8.1	Team NW	Team Center
F3.2.2	Team NW
F5.2.3	Team Head	Team Head

<tbody>
</tbody>

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!