Split Data in Table To Multiple Rows Based On Delimited Text In Columns

[Rick Rothstein]

Your input table shows two columns that have delimited value. Can you post a sample of what is the expected output.

Actually, I cannot tell what is in his columns when I paste them into a worksheet (I get some merged cells resulting). A suggestion to nick5_86... list the cells and next to them their content, something like this...

C1 - L1A1
C2 - L1C1
etc. for Column C

D1 - L1B1,L1B2
D2 - L1D1,L1D2
etc. for Column D

Although use your actual values as I am not sure the above is correct. Then show us you expected output in the same way.