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.
Step 1
Select the column which contains the data and go to Remove Duplicates in Data ribbon, your duplicates will be removed in the same place.
Step 2
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.
Step 3
You can see that our product column does not have any duplicate values now.
Hope this helped.