PQ - Match across tables - and pick up values

(question from the web)

Quote:

---

I have two tables, TableA and TableB (both the result of Power Queries against separate source files) - they have one common column (email_address) - then a number of columns ...

I want a Power Query that creates TableC that starts with TableA - with columns from TableB populated if there is a match on the email_address (and if there is no match "null" is OK, but "No Match" would be even better) ...

But I can't get my head round how to do this in Power Query (I have INDEX/MATCH working, but need it dynamic hence a Power Query)?

I know I need to create custom columns for the columns from TableB, but it's the actual query I'm struggling with!

---

I hink merge tableA and tableB by email column and expand appropriate columns if needed