Sort on rows (not columns)

P

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
 
G

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.
 
Top