Take distinct values from two different columns in two different tables and create a new table

[DarylRob]

Hi, 

So I've got two tables both with Account Manager columns, for example

Table 1:

Gary

Gary

Dave

Terry

Billy

Billy

Table2:
Jenny

Jenny

Dave

Billy

And i want to then create a new table with:

Gary

Dave

Terry

Billy

Jenny

I've tried using summarize and distinct but to no avail...

[amitchandak]

@DarylRob , Create a new table

Name=

distinct(union(distinct(Table1[Name]),distinct(Table2[Name])))

[DarylRob]

Perfect, thanks. But now i'm trying to create a relationship between the two fields but it won't create a many-to-one relationship instead only able to create a many-to-many. Any ideas?