Merging two columns of information

One problem solved and one to go. For now

I have two very long columns of client names. The columns represent reports that were run at different times on the same information.

What I want to do is merge the two clomuns. The issue is that there are many names that are the same but some that are different. Is there a way that you can merge the info. So it ignores the client names that are the same but auto adds the ones that are new. There are financials in other columns that I want to have come along during the merger. Thanks