How to use this tool
- Import your file and open the empty-row operation. Compare the detected rows with their source positions.
- Review the proposed removals. A row qualifies when every cell is empty or contains only whitespace.
- Confirm the removal and check the new row total. Review partially populated records separately under missing values.
Worked examples
| Original data | After review |
|---|---|
| Three empty fields in one record | The row is removed |
| Order 0048 with two blank fields | The row is kept |
Frequently asked questions
Does a value of zero make the row empty?
No. Zero is a value. The row remains in the dataset even when all its other fields are blank.
Will a row containing N/A be removed?
N/A is written text. If the source uses it to mean missing, review the missing-value token operation before deciding whether the resulting row should be removed.
