View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SmilingPolitely[_3_] SmilingPolitely[_3_] is offline
external usenet poster
 
Posts: 14
Default 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.