software

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: www.excelforum.com/member.php...oamp;userid=32344
View this thread: www.excelforum.com/showthread...hreadid=523114Hi

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

Andy.

quot;po2206quot; gt; wrote in
message news
gt;
gt; Hi
gt;
gt; I have a dataset that contain many columns with data. The first row
gt; contains the column headers. Is there any way to sort the columns on
gt; headers? An example is probably needed:
gt;
gt; C A B
gt; 4 3 8
gt; 3 4 8
gt; 6 2 9
gt;
gt; I want to sort on headers so it will look like this:
gt;
gt; A B C
gt; 3 8 4
gt; 4 8 3
gt; 2 9 6
gt;
gt; Any input? It is not an option first to transpose the data, as the
gt; sheet contains 50K rows.
gt;
gt;
gt; --
gt; po2206
gt; ------------------------------------------------------------------------
gt; po2206's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32344
gt; View this thread: www.excelforum.com/showthread...hreadid=523114
gt;

Thanks a million. That saved the day :-)--
po2206
------------------------------------------------------------------------
po2206's Profile: www.excelforum.com/member.php...oamp;userid=32344
View this thread: www.excelforum.com/showthread...hreadid=523114