need to split cells into rows

[patchypich]

Hello,

I need to split colum F, they are comma delimited, I can use the text to column command but it puts the value into a new column. I need it in the row along with its proper easting and northing values. So it should insert a new row and copy the A, b, and C column and the split cell value.

attached is an example of the problem.