Forum Discussion
Sorting grouped rows - troubleshooting
I have been working on a problem in a sheet I have been building to track grants and projects for my program. In this sheet, data is sorted by grant IDs and their associated projects. Grants are grou...
Table sorting doesn't work like this. You must make sure all rows of the grouped columns contain data. All rows about grant AAA must have AAA in the first table column, and etcetera.
Once you've filled your table like that, consider creating a pivot table from the raw table rather than using the grouping option. It is always a better idea to keep your data as is and do the analysis elsewhere in the file.
To get your blanks filled:
- Select the columns containing blank cells
- Press the F5 key, then click "Special"
- Select "Blanks"
- Hit the = sign on your keyboard and then press the up-arrow key once.
- Press Control+Enter
- Now select those same columns again
- Hit control+C
- Do a paste-special, Values only.
Once you've filled your table like that, consider creating a pivot table from the raw table rather than using the grouping option. It is always a better idea to keep your data as is and do the analysis elsewhere in the file.
To get your blanks filled:
- Select the columns containing blank cells
- Press the F5 key, then click "Special"
- Select "Blanks"
- Hit the = sign on your keyboard and then press the up-arrow key once.
- Press Control+Enter
- Now select those same columns again
- Hit control+C
- Do a paste-special, Values only.