Match & Merge Data From 2 Spreadsheets

[meir0082]

Hi I have 2 spreadsheets, I need to only merge data from one when there is matching data in a cell in the other. Is there any way to do this? Example:
Table A

Code	Name
AAA111	A
BBB111	B
CCC111	C

Table B

Code	Name
AAA111	A
CCC111	C
DDD111	D

I only want excel to pull AAA111 and CCC111 but skip BBB111 as the is no matching data in table b

 

[alansidman]

Load each table to Power Query Editor and then Join the tables with a left outer join on the Code

let
    Source = Table.NestedJoin(TableA, {"Code"}, TableB, {"Code"}, "TableB", JoinKind.LeftOuter),
    #"Expanded TableB" = Table.ExpandTableColumn(Source, "TableB", {"Code", "Name"}, {"TableB.Code", "TableB.Name"})
in
    #"Expanded TableB"

Book8
	A	B	C	D	E	F	G	H	I	J
1	Code	Name		Code	Name		Code	Name	TableB.Code	TableB.Name
2	AAA111	A		AAA111	A		AAA111	A	AAA111	A
3	BBB111	B		CCC111	C		CCC111	C	CCC111	C
4	CCC111	C		DDD111	D		BBB111	B
Sheet1