We have Product data in column A and you can see there are a lot of duplicates values, we want only the unique values of product.
Select the column which contains the data and go to Remove Duplicates in Data ribbon, your duplicates will be removed in the same place.
You will get a pop up like below
You could check/uncheck the “My data has headers” checkbox depending on your selection contains header or not. If there were more than 1 column from which you wanted to remove columns, you would have to select those columns and press OK.
You can see that our product column does not have any duplicate values now.
Hope this helped.