Hi,

I'm trying to append two tables using power query (PQ) (Excel 2010).

The two tables are very simple:

Table 1 has 2 columns: ID + Supplier name (no null rows).
Table 2 has also 2 columns: ID + Brand name (no null rows).
Where the ID columns (item id) is identical for both tables.

After loading these two tables into PQ, the combined table is not ok: in the beginning I get ID rows + supplier name where brand name is null for all rows, and then ID rows + brand name where supplier name is null for all rows.

I was expecting to get a combined table with 3 columns where ID field appears only once, and for each ID row to see supplier name and brand name.

Hope my question is clear.

Thanks