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.
|No data here|
Objective: remove empty rows, ignore column [Note].
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.