Hi,
I have only a few minutes before I leave, therefor you get a short explanation to a solution.
First: Make a backup of your sheet, then mark all your data and take away the concatination (at all cells).
Insert one row at the top.
Copy the cells I1:AA3 in the attachment and paste it into the same cells in your sheet.
Mark the complete columns K:L and name this area "Data"
Mark cells I3:AA3. Copy these cells down as far as you have data.
Now the columns M:AA should contain your wanted result. If you have more than 15 competences per employee (check max of column J to see this), you must extend the columns further to the right of AA.
Now mark all cells in the columns I1:AA9999 (as many lines you have). Copy... Paste special... values.
Delete the columns H:L.
Done!
Please don't hesitate to ask question. I hope a got the explanation right
Must hurry!
Kind regards
Bjorn