Sort alphabetically, which will group blank cells after filled cells.
If you need to revert back to the order the rows are currently in,
1. Insert a column and number each column;
2. Alpha sort on a column that contains blanks;
3. Delete rows that contain a row number and blanks;
4. Sort on the row number column.
|