Creating a single table from 2 tables

in Power Query (replace the red code with your references)

let
    Tab1 = Table1,
    Tab1_single_column = Table.SelectColumns(Tab1,{"Id"}),
    Tab2 = Table2,
    Tab2_single_column = Table.SelectColumns(Tab2,{"Id"}),
    #"Appended Query" = Table.Combine({Tab1_single_column, Tab2_single_column}),
    #"Removed Duplicates" = Table.Distinct(#"Appended Query")
in
    #"Removed Duplicates"

Use the Append Query and then You would arrive at below result

Then you can right click on the account number and click Remove Duplicates. This will help to remove the duplicated Account Value. Finally you will arrive at below.

Hope this helps :smileywink: