You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later unfilter the sheet.

Removing these spaces can help the Remove Duplicates tool to better detect the duplicate values you want to remove. Think you know how to use Excel?