Sort table using function/equation only

[bdtran]

Hello All,

How can I sort a table into another table on the same row in different columns as shown in the example below.

The sort based on data in the row #2 from high to low (descending).

Thanks in advance for any helps.
*BDT



[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Source[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]Sorted[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Table >[/TD]
[TD]6[/TD]
[TD]3[/TD]
[TD]9[/TD]
[TD]20[/TD]
[TD]15[/TD]
[TD]Table >[/TD]
[TD]20[/TD]
[TD]15[/TD]
[TD]9[/TD]
[TD]6[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]6[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]6[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]8[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Yongle]

Excel Data Sort allows user option to sort data by row instead of by column