Merging 3 Columns together

[arjunt1216]

Hi say i have 3 tables each have a column "Color" that I would like to merge into one column. 

Name	Color
Ross
Joey
Monica	Green
Phoebe

Name	Color
Ross	Red
Joey
Monica
Phoebe	Orange

Name	Color
Ross	Red
Joey	Blue
Monica
Phoebe

Joining on Name does not merge the columns. I tried using a formula to concatenate the 3 columns, but the row "Ross" comes up with "RedRed". I would ideally like a table like this. How could  i do this? Thanks!

Name	Color
Ross	Red
Joey	Blue
Monica	Green
Phoebe	Orange

[MilindG · Accepted solution]

@arjunt1216 Can you try to union and then use unique value?

[alexnajm · Accepted solution]

Like such?

[arjunt1216]

Thank you, both solutions produced the ideal output