Sorting with matching header

[TouchTone]

Hi

I need some solutions to the following. Please help.

Original

Supplier 1 Supplier 2 Supplier 3 .......
Product 1 5 10 15
Product 2 10 8 9
Product 3 15 25 4
..
..
..
Sort Results wanted to be as show

Product 1 Supplier 1, Supplier 2, Supplier 3
Product 2 Supplier 2, Supplier 3, Supplier 1
Product 3 Supplier 3, Supplier 1, Supplier 2

 

[bj]

if your suppliers are in row 1 and product in column a
copy the product names to another location (A11?)
and in B11
=INDEX($B$1:$D$1,1,RANK(B2,$B2:$D2,1))
copy and paste to B1113