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" wrote in
message ...
Hi
I have a dataset that contain many columns with data. The first row
contains the column headers. Is there any way to sort the columns on
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 the
sheet contains 50K rows.
--
po2206
------------------------------------------------------------------------
po2206's Profile:
http://www.excelforum.com/member.php...o&userid=32344
View this thread: http://www.excelforum.com/showthread...hreadid=523114