This is an old revision of the document!
Remove empty rows
Category: Transform / Advanced.
This action removes empty rows, or rows that don't look empty and don't have any meaningful information (e.g. whitespace values). For convenience, certain columns can be ignored if they have non-empty values which are not necessary.
Example
Source dataset:
| Product name | Qty | Price | Note |
|---|---|---|---|
| Big thing | 1 | 1000 | |
| No data here | |||
| Medium thing | 10 | 100 | |
| Small thing | 100 | 10 |
Objective: remove empty rows, ignore column [Note].
Result:
| Product name | Qty | Price | Note |
|---|---|---|---|
| Big thing | 1 | 1000 | |
| Medium thing | 10 | 100 | |
| Small thing | 100 | 10 |
Use cases
The action can be convenient for removing empty rows without using a filter. When empty rows are removed using a filter applied to 1 or several columns there is always a risk that important data may reside in columns not included in the filters and thus accidentally removed. The "Remove empty rows" action reduces this risk and guarantees that only rows without meaningful information will be removed.
See also