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

Attached Files

Transpose_special.xls (33.5 KB, 21 views)