Sort by rows...

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

Bernie Deitrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top