Two Columns Combined into One Column w/ No Duplicates

Hi,

I am looking for an equation that takes two columns of Names and removes duplicates and shows the results in a separate third column. Attached is a file with an example of the issue along with the details of what I am trying to accomplish.

Thanks!

Two Columns into One Removing Duplicates.xlsx

try this formula in column D..

=IF(ISERROR(MATCH(C3,$B$2:$B$8,0)),C3,"")