In the Excel worksheet where you want to combine two columns of data, first insert a new column near the data you want to combine. This is where your combined data will be displayed.

However, you can also use conditional formatting to compare two columns in Excel. ... To single out entries that appear in only one column, click on Duplicate and switch to Unique in the dialog box.

However, you can also use conditional formatting to compare two columns in Excel. ... To single out entries that appear in only one column, click on Duplicate and switch to Unique in the dialog box.