How to Merge Two List without Duplicates in Excel

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.

merge two list without duplicates1

#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.

merge two list without duplicates2

#3 go to DATA tab, click Remove Duplicates command under Data Tools group. And the Remove Duplicates Warning dialog will appear.

merge two list without duplicates3

#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.

merge two list without duplicates4

#5 click Ok button. You should see that all duplicate values found and removed.

merge two list without duplicates5



You might also like: