I have a text line containing information separated with pipe sign [|].
Kindly provide me a macro/code to break them into:
a. Each broken value should be moved to a new row downwards.
b. Multiple cells towards right.
Column 1 / Row1
NM: Robert Cox, CPA|NM: Todd Hess, CPA|NM: Jim Wilson, CPA