This group has two buttons – one for removing duplicated 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 affects only the selected column.
This is the result of this operation:
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.