This group has two buttons – one for removing duplicate values and the other one to remove empty rows.
Remove Empty Rows
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
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.
