This could be a very common scenario for a lot of people, take a look.

The task is to transpose each row of training programs into separate columns like the table on right (in green).

Once the data is loaded to fill the empty rows with Emp Code and Name, select both Emp ID and Emp Name Column in the Right Click menu choose Fill Down.

This will let you remove duplicate Employee rows and yet somehow retain the Training information.

To get around that well be creating a List (meaning a single columnar data) which can be clubbed together in a single cell.

Click on Custom Column from the Add Column Tab and write the following Formula.

Simply Click on Double Headed Arrow Icon in the Header Training List and choose Extract Values Choose a Delimiter.

Of course after removing any junk columns our data looks like we wanted.

Please drop me a comment, in case you are interested in my training consulting services.