View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
po2206
 
Posts: n/a
Default Sort on rows (not columns)


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