How to collect all values in 9 columns across 3 tables into 1 column in another table?

[Lexicon]

I have 3 tables, each with 3 "user" columns

Employee	Buddy	Manager
Alex	Barry	Claire

Employee	Team Lead	Manager
Francis	Alex	Claire

Employee	Supervisor	Department Manager
Clair	Patrick	Sophie

I want a new table that has ALL the users that are present in those 3 tables in any way.

User

Alex

Barry

Claire

Francis

Patrick

Sophie

I don't know where to begin. Can someone help please?

[Lexicon · Accepted solution]

Never mind, I got it!

I know there's a shorter way to write this but this is way less brain-taxing to read.

let
    User1 = Table1[User_Employee],
    User2 = Table1[User_Buddy],
    User3 = Table1[User_Manager],
    User4 = Table2[User_Employee],
    User5 = Table2[User_TeamLead],
    User6 = Table2[User_Manager],
    User7 = Table3[User_Employee],
    User8 = Table3[User_Supervisor],
    User9 = Table3[User_DeptManager],
    AllUsersList = List.Combine({ User1,User2,User3,User4,User5,User6,User7,User8,User9}),
    AllUsers = Table.FromList(AllUsersList),
    #"Removed Blank Rows" = Table.SelectRows(AllUsers, each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null}))),
    #"Removed Duplicates" = Table.Distinct(#"Removed Blank Rows")
in
    #"Removed Duplicates"