Duplicates

This group has two buttons – one for removing duplicated values and the other one to remove empty rows.

Remove Empty Rows

Text

Description automatically generated with medium confidence

Click a cell inside a column. If there is an empty cell in that column, it removes it. It affects only the selected column.

This is the result of this operation:

Remove Duplicates

Graphical user interface

Description automatically generated

Click a cell inside a column. If there are two identical cells in this column the duplicated column is removed even if values in other cells are different.

This is an example table:

After you click the button, all duplicate rows based on the selected column are removed.