Unable to merge tables in power query

[Anonymous]

I really want to merge two tables. The first table is sample contact_list, the second table is reminder list_to do. These two lists are similar in some columns: they both have ID column, code number, name used by supplier, supplier for purchase, manufacturer, and email address 1. The sample contact_list is full but the reminder_list to do has fewer items. However, I want to compare these two lists and add on those new added differences in sample contact_list to the reminder list_to do. I used the ID column they both have as a primary key. However achieve this goal?

I've tried the method to "merge query" and use "Full Outer", but the problem is that they are not matched in columns. The first several columns are from sample_contact list with null information from reminder_list to do, and remaining later coluumns are from reminder_list to do, but the cells for sample_contact list are empty. How to solve this issue. I used my graph below to help you understand what do i mean. 

Can someone help me? Thank you so much again. 

[dufoq3]

Hi, could you provide dummy data from both tables?

let
    SourceTableA = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUXJUitWJVjICsSBMYzATwjaBsCEcUygHyIsFAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, #"Data A" = _t]),
    SourceTableB = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUXJSitWJVjICssAMY5CQE0TQBCZoChEECccCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, #"Data B" = _t]),
    #"Merged Queries" = Table.NestedJoin(SourceTableB, {"ID"}, SourceTableA, {"ID"}, "SourceTableA", JoinKind.LeftOuter),
    #"Expanded SourceTableA" = Table.ExpandTableColumn(#"Merged Queries", "SourceTableA", {"Data A"}, {"Data A"})
in
    #"Expanded SourceTableA"

[Anonymous]

1	50550086	Product 1 x1	company 1	1st person	jjj@abcd.com
2	50575853	Product 2 x2	company 2	2nd person	aaa@abc.com
3	50575853	product 3	company 3	3rd person	bbb@abc.com
4	50549642	ACETIC ACID GLACIAL	company 4	4th person	ccc@abc.com
5	50576163	ACETONE	company 5	5th person	ddd@abc.com
6	50576163	ACETONE	company 6	6th person	eee@abc.com

This is the first table i need to use, the heading for each column is index number, code number, product name, company name, owner name and email address. The second table is similar to this table, it's just they are different index number, so like this

9	50576163	product 9	company 9	9th person	acd@abcd.com
10	50576163	product 10	company 10	10th person	efg@abcd.com
11	50576163	product 11	company 11	11th person	dqm@abcd.com

Sometimes maybe the second table has some specific rows same as the same table, i just want to keep the value in the first table, and not add those duplicates one into the table using Merge. 

[dufoq3]

You can do merge i.e. with [Code Number] columns.