Is there a way to sort columns
 

I am familiar how to sort data in columns e.g.

oranges apples
2 8
3 7
1 5

sorting by oranges returns
oranges apples
1 5
2 8
3 7

and by apples B etc..

BUT is it possible to sort the columns themselves into alphabetical
order? returns

apples oranges
8 2
7 3
5 1


Any help would be appreciated.

Is there a way to sort columns
 

SmilingPolitely wrote:
I am familiar how to sort data in columns e.g.

oranges apples
2 8
3 7
1 5

sorting by oranges returns
oranges apples
1 5
2 8
3 7

and by apples B etc..

BUT is it possible to sort the columns themselves into alphabetical
order? returns

apples oranges
8 2
7 3
5 1


Any help would be appreciated.


dont worry. got it.

Is there a way to sort columns
 

in the data-sort window click options and click <sort left to right and
normal and choose <row1)
(assuming texts oranges and apples are in first row.)

SmilingPolitely wrote in message
...
SmilingPolitely wrote:
I am familiar how to sort data in columns e.g.

oranges apples
2 8
3 7
1 5

sorting by oranges returns
oranges apples
1 5
2 8
3 7

and by apples B etc..

BUT is it possible to sort the columns themselves into alphabetical
order? returns

apples oranges
8 2
7 3
5 1


Any help would be appreciated.


dont worry. got it.