Say I have two tables, both listing ID number and some value, for example,

Table 1

 ID  Value
 1   A
 1   B
 1   C

Table 2

 ID Value
 1  A
 1  D
 1  E

Using Power Query I would like to merge both tables in a way so if there is no matching value, the “missing” values are still listed, so the expected result of the above tables would be:

 ID Value 1 Value 2
 1  A       A
 1  B
 1  C
 1          D
 1          E