View Single Post
  #5   Report Post  
Dave O
 
Posts: n/a
Default

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.