This post will guide you how to merge two list without duplicates in Excel. How do I combine two columns of data with remove duplicates command in Excel.
Merge Tow List of Data
Assuming that you have two list of data, and you want to merge them in the third list without duplicates in your worksheet. How to do it. You can use the Remove Duplicates command to remove duplicate values firstly, then copy one list into another list. Let’s see the following introduction.
#1 select the first list of data, and press Ctrl + C keys on your keyboard.
#2 select one cell on the bottom of the anther list of data, and press Ctrl + V to paste it. And keep to select the entire list of data.
#3 go to DATA tab, click Remove Duplicates command under Data Tools group. And the Remove Duplicates Warning dialog will appear.
#4 select the Continue with the current selection option in the Remove Duplicates Warning dialog box. And click Remove Duplicates button. And the Remove Duplicates dialog will open.
#5 click Ok button. You should see that all duplicate values found and removed.