D
Darin Kramer
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 ***
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 ***