Sort on rows (not columns)

[po2206]

Hi

I have a dataset that contain many columns with data. The first ro
contains the column headers. Is there any way to sort the columns o
headers? An example is probably needed:

C A B
4 3 8
3 4 8
6 2 9

I want to sort on headers so it will look like this:

A B C
3 8 4
4 8 3
2 9 6

Any input? It is not an option first to transpose the data, as th
sheet contains 50K rows

 

[Guest]

Hi

Select your area to sort. Go to Data/Sort and click on the Options button.
This gives you a 'left to right' sort.

Andy.

 

[po2206]

Thanks a million. That saved the day