Create new column (table) with unique values from two other columns.

[Anders_G]

Power Query : I want to create a new Table C with a column showing the unique values from two other columns in two different tables A & B. See example below.

I'm sure this is easy but I'm stuck with this one.

Thank you!

[Anonymous · Accepted solution]

Hi,

I solved it this way: Append queries as new-> remove duplicates

let
Source = Table.Combine({Table1, Table2}),
#"Removed Duplicates" = Table.Distinct(Source)
in
#"Removed Duplicates"