Want to split a table based on values in a column

Hi all,

I want to split data in a table based on a column, where the column is having multiple values separated by a "/". All those separate values should form a separate line in the table.
Also, data in said column has non-uniform spacing which you can see if you give a closer look.

Thanks in advance.

Dominic.

It worked for me. Thank you so much. But after i put the code in my excel sheet, i am getting the message, "Be careful ! Parts of your document may include personal information that can't be removed by the document inspector", even when i am trying to save other excel workbooks other that the one in which i pasted the code. Do you have any idea why the message is coming up ?

It worked for me Alan. Thank you.