Howdie ya all :)

I have a series of data 250 columns wide.
In Row 1 is a code, (alpha)
Cells 2 - 130 of each column has information in it.

So, eg A1 = mice
A2 = 10
B1 = Cat
b2 = 15
C1 = Dog
c2 = 20
etc, for 130 rows for 250 columns

I want to be able to alphabetically sort by the first row, so that my
result will be:
a1 = Cat
a2 = 15
B1 = Dog
b2 = 20
C1 = Mice
c2 = 10

etc

Any ideas...? Paste transpose and repaste transpose...?

Kind Regards

D




*** Sent via Developersdex http://www.developersdex.com ***