Sort by rows...
 

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 ***

Sort by rows...
 

Darin,

Select your data table, choose Data / Sort, then click the Options button and select "Sort left to
right", then do your sort.

HTH,
Bernie
MS Excel MVP


"Darin Kramer" wrote in message
...
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 ***

Sort by rows...
 

So easy!! Thanks D


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