List all records with unique id

[merkle09]

Hello, 

I'm trying to provide a solution for the below in power query. I have two tables. 

1. Payments Table shows all of the expected payments/deliverable that will be due. 

2. Bank accounts table shows the bank account information related to each possible expected payment/deliverable that will occur in payments table. Some payments/deliverables will only have a transaction in 1 bank account, thus 1 rows of data in this tables and others may affect 2 (or more) bank accounts, thus they will have 2 (or more) rows of data in this table. 

For all of the payments/deliverables in table 1, I want to relist these payments/deliverables with the ALL corresponding bank account table records that match the ID, whether just 1 line (ID: CX01) or 2 or more lines (ID: CX02). 

This is a very small sample size is very small , but the same logic will apply to a much larger data set. 

The final output I would like will be something like the New Output Table

[merkle09]

This worked perfect, thanks!

[ImkeF · Accepted solution]

Hi @merkle09 ,
joining both tables on their first 3 columns should do the job here:
Start with the first table (on the left side) and then join the second one to it, using ID, Company and Deliverable as the join columns.