Merge 2 Tables

Full Outer Joins. 

--Nate

Hi,
But Full outer join will print both tables record right, I only wanted to see the non-existing item of my first table into my merging table

Oh ok. That is JoinKind.Right.Anti

--Nate

For each new data column, remove the values in the columns to the left and then combine them.

Full sample query you can paste into the Advanced Editor of a new blank query:

let
    DATA1 = #table(type table [DATA1 = text], {{"A"},{"B"},{"C"},{"D"},{"E"},{"F"},{"G"}}),
    DATA2 = #table(type table [DATA2 = text], {{"A"},{"D"},{"G"},{"J"},{"H"},{"I"}}),
    DATA3 = #table(type table [DATA3 = text], {{"B"},{"J"},{"L"},{"K"},{"M"},{"N"}}),
    List1 = DATA1[DATA1],
    List2 = DATA2[DATA2],
    List12 = List.Distinct(List.Combine({List1, List2})),
    Table1 = DATA1,
    Table2 = Table.SelectRows(DATA2, each not List.Contains(List1,  [DATA2])),
    Table3 = Table.SelectRows(DATA3, each not List.Contains(List12, [DATA3])),
    Source = Table.Combine({Table1, Table2, Table3})
in
    Source

(If you have DATA1, DATA2, DATA3 defined as separate queries, remove those definitions from the query above.)