Merge List of different activities for each Category of employee to a list of employees

Dmercier I guess this is something that it well suited to Power Query. Are you familiar with that?

The attached file has a working solution based on your example. One structured table named "Capabilities" and one called "Employees". 

First, clean up both tables a bit, merge them and do some final cleaning and load the end result back to Excel. May be a bit confusing if you have never used it before. 

Give it a try. Use the attached file. Delete the original tables (keep the green one though) and create two new ones (anywhere within the workbook) containing all data, with the same table names as mentioned above. It's important that the real tables have exactly the same structure and column names as the ones in your example. Once done, press Refresh All on the Data ribbon and the green table should updated in a matter of seconds. No copy / paste needed. 

Come back here if you have any problems.