Merge
Power Query's join: matching rows of two tables on key columns and bringing matching rows across as a nested table.
A merge adds a column of nested tables containing the matching rows from the second table; you then expand the columns you need or aggregate them. The join kind decides which rows survive, and the keys must have the same type and clean values on both sides.
In the Power Query editor
Home → Merge Queries, which writes Table.NestedJoin followed by an expand step.
Learn more
Related functions
Practise it
- intermediate~9 minPro
Look up each order's customer city (kite shop)
Merge Orders with Customers on Customer and expand City, keeping every order.
- intermediate~8 minPro
Find orders from unknown customers (kite shop)
Use a left anti join to list orders whose customer isn't in the customer master.
- beginner~6 minPro
Keep only enrolments for courses that are still running (college)
Enrolments refer to course codes; the Courses table lists only courses still running. Keep matching enrolments with their title.
- advanced~14 minPro
Reconcile bank and ledger with a full outer join (charity)
Match bank lines to ledger entries by Ref and flag what's only in the bank, only in the ledger, or in both.