Merging two columns of Names to One Column

New Contributor

Im having a problem trying to merge two column of names to on single column with applying a rule of if there is duplicate names in column A and column B then column C will be all the names that were not duplicates in Column A&B

3 Replies

Excel has the option "Remove duplicates"! Have you tried? You need to have all cells on the same column though.


 Sorry that's Italian, but you can find your way comparing the icons ;)


But, if you don't want (or you can't) use that, you can try in the way I used in the attached file.



Thank you for your reply. Its a bit more that the duplicate and the attach file you sent over. I attach a sample of what i am trying to do. If column A and column B have a match i want column E to have all the matches.

If you add desired result to the sample it'll be easier. Do you mean matches for columns A and C (A and B never matches)? In E in first row it'll be "Blocker, DeBisschop" or what?

Related Conversations
Last Value Column from Another Column in Same List
Yepitsme in SharePoint on
6 Replies
Add Column Using Count
Tim Hunter in SQL Server on
0 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies