Excel is a powerhouse at transforming and ... section in the Home tab and click on the dropdown arrow. Now, select the "Remove Duplicates" option, and your selected columns should now only have ...