Looking to extract multiple matches from a list

You can enter the Query Editor in sample file. You can follow each applied step in right hand pane.

Basically, after you merge the tables using Left Outer Join. You'd use below formula construct.

=Text.Combine([TableName][ColumnName],", ")

Where TableName is actually the column name of the merged column. And ColumnName is the target column of the source table.