Delimite pipe (|) separated values to single column

'ROWS TO COLUMNS
Here's a macro for expanding rows of data to multiple rows parsing out the delimited values in one column while duplicating all the others.

Rows to Columns - Part 2

Just edit the Col = 3 code to Col = 2 and run it on a copy of your data, should do what you want. There's a sample workbook too you could drop your data into and test it out.

Thank you for prompt response. The macro worked smoothly. However, I feel only problem with macro is that, original data gets replaced by new dataset.