Power Query Merge on multiple columns

[SeanB004]

Hi all, 
I have 2 tables one with activities and employee ids and another with employee id and full name of employee. I need to merge the Activities table to the employees table to get the full name. The trick is the activities table has multiple columns with id's.:
Activities table

Employees table:

The end goal is to merge the 2 tables to get the full names into one row but separated by a comma delimiter in the Activities table.

[Anonymous · Accepted solution]

Hi @SeanB004 

First, for each ID column in the table, you'll need to perform a merge operation with the table.

After merging, you will have additional columns containing the full names. You may need to expand these columns by clicking the button on the header of the merged column. Then add a custom column where you concatenate the full names from the expanded columns, separating them with a comma. Use the formula like

Result:

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.