New here -

I need to separate multiple values separated by a pipe in a single cell in column J into individual rows. I also need that the data in the adjacent columns of the original cell also to be repeated in the new rows. My data set is large 5000+ rows.

example attachedhelp.xlsx