Excel 2007 : transpose & sort

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

Need help in transpose as show in example. Many thanks in advance.

Organization ID Contact Name E-mail Address
a1 xyz x1.com
a1 szx x2.com
a2 abc a1.com
a2 bcd s2.com
a2 cef s3.com

After formatting:
Organization ID Contact Name E-mail Address Contact Name E-mail Address Contact Name E-mail Address
a1 xyz x1.com szx x2.com
a2 abc a1.com bcd s2.com cef s3.com