Duplicates

This group has two buttons – one for removing duplicate 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 checks only the selected column. The table should start with column A.

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 duplicate column is removed even if values in other cells are different. The table should start with column A.

This is an example table:

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