consolidate txt from multiple columns into one column & remove duplicates

I have a worksheet with two columns of names. Some of the names appear more than once. Is there a formula (not a macro) which can consolidate all of the names into one column, and remove duplicates?

I've attached a worksheet as an example.

Thanks!