Merge Columns from 2 Tables only if value is in both columns

[scojax22]

I have 2 tables with multiple columns in each, but one common column - names. I want to create a new table with just the names column, only where the name is in both tables/columns. Something like this:

Table 1		Table 2		New Table
Joe		Bill		Joe
Bob		Timmy		Ray
Ray		Joe
Ben		Jay
Jim		Will
Barry		Ray

I am trying to do this is Power BI

 

[jdellasala]

A simple Inner merge will do it. Take a look:

After bringing Table1 and Table2 into Power Query, do the merge. This is a Merge as a New query, but it could be done in either table:

let
    Source = Table.NestedJoin(Table1, {"Table 1"}, Table2, {"Table 2"}, "Table2", JoinKind.Inner),
    RemovedColumn = Table.RemoveColumns(Source,{"Table2"}),
    RenamedColumn = Table.RenameColumns(RemovedColumn,{{"Table 1", "New Table"}})
in
    RenamedColumn

Book1
	A	B	C	D	E
1	Table 1		Table 2		New Table
2	Joe		Bill		Joe
3	Bob		Timmy		Ray
4	Ray		Joe
5	Ben		Jay
6	Jim		Will
7	Barry		Ray
Sheet1

 

[scojax22]

Thanks for the reply.

 

[Peter_SSs]

Thanks for the reply.

If the suggestion worked for you then please mark that post as the solution. If no post has answered your question then please do not mark one as the solution. I have removed the solution mark from post #3.