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

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Source	1	2	3	4	5	Sorted	4	5	3	1	2
2	Table >	6	3	9	20	15	Table >	20	15	9	6	3
3		2	3	6	5	7		5	7	6	2	3
4		6	7	8	5	1		5	1	8	6	7

<tbody>
</tbody>

 

[Yongle]

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