Thread: Sorting columns
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Joyce Joyce is offline
external usenet poster
 
Posts: 106
Default Sorting columns

Yes. That's what i'm trying to do. This is what i have:

A B C D E F G
------------------------------------------------------------------------------------
20 20 20 20 20 20 20
25 20 20 20 20 20 20
12 12 12 12 12 12 12
12 12 12 12 12 12 10
12 15 13 15 15 15 15
20 20 20 20 20 20 20
13 12 12 12 12 12 15
5 5 4 4 4 4 5
20 20 15 20 20 20 15
13 13 13 13 13 13 13
14 14 12 14 14 14 14
24 20 20 20 20 20 20
15 15 15 15 15 15 15
17 15 15 15 15 15 15
13 13 14 14 14 14 15
20 20 20 20 20 20 20


* That's just a small part (they go up to 26 columns & may be 70 rows) *

As you can see, every column has similar values on their rows. I want to
sort the columns without alterting the individual rows. In other words, when
i sort them out i don't want to end up with A2 in D7. If that happends I
wouldnt know what is what.

Whenever i try to sort them out i end up with something like:

A B C D E F G
------------------------------------------------------------------------------------
3 3 2 2 2 2 2
3 3 2 2 3 2 2
3 3 3 3 3 3 3
4 4 3 4 4 4 3
4 8 5 4 4 5 4
4 4 3 4 3 4 3
5 5 4 4 4 4 5
6 10 5 6 6 6 6
6 6 6 6 6 6 7
6 6 6 6 6 6 7


That i dont' want. It's sorting from smallest to largest but for every
individual column.

Am I explaning myself?

--
Joyce @ fMX


"Jim Cone" wrote:

Kassie,
Maybe Joyce is actually trying to sort the columns not the rows?
--
Jim Cone
Portland, Oregon USA