Power Query 2 Excel Files

[jimmycooker]

Hi,

I am trying to 'Merge' two queries so i get all the rows in Table 2 that have a match in Column 'A' in Table 1.

Is Merge the correct way to go and if so what options do i use to get the desired result?

Thanks In Advance,
James.

 

[alansidman]

Yes, you should be able to join the two ranges/tables in Power Query. Join table 1 to table 2 with a left join.