hi,
I need to transpose and sort smallest through largest at the same time. I have a huge list so I need a formula to come up with same as below:

A B C D E F G
1 BPA 14.3 10.63 11.20 11.78 12.41 14.30
2 BPA 12.41
3 BPA 11.78
4 BPA 11.2
5 BPA 10.63

thanks
Ola