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 |
Sort on rows (not columns)
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 |
Sort on rows (not columns)
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 |
All times are GMT +1. The time now is 10:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com