CleanMySheet guide

Drop empty rows and columns from a spreadsheet

Drop empty rows/columns removes records where every cell is blank and columns where every value is blank. Run Unify empty values first so N/A counts as empty.

Steps

1. Unify empty values
2. Apply Drop empty rows/columns
3. Check row counts in the toolbar