| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sort by row instead of by column?
"PercivalMound" wrote: In Excel 2003, I have a range 50 columns wide and 600 rows tall. Row 1 has the column headings, while Rows 2-600 contain the data pertaining to the column heading shown in Row 1. Now I want to sort the entire range according to the column headings, so that Location 1, which now occupies the first 600 rows of Column M, will end up in Column A; Location 2, which now occupies 600 rows of Column AE, will end up in Column B; and so on, each column carrying along with it the cells under that column heading. The Data Sort menu command will sort by column, but how do I sort by using Row 1 as my index? More to the point, why has Excel been designed to sort rows according to column, but not sort columns according to row? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I sort a column with several categories (ie red and blue) | Excel Worksheet Functions | |||
| How do I sort a column of street number/street name by the stree. | Excel Worksheet Functions | |||
| "-" ignored in sort | Excel Discussion (Misc queries) | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
