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

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

Thanks a million. That saved the day :-)


--
po2206
------------------------------------------------------------------------
po2206's Profile: http://www.excelforum.com/member.php...o&userid=32344
View this thread: http://www.excelforum.com/showthread...hreadid=523114