Redistribute a Delimited Column Of Data into Separate Rows (Keeping Other Data As Is)

[tunderwat]

Thanks Rick! I was running into trouble with something similar and found your macro. All I did was change Const Delimiter As String = ", " to Const Delimiter As String = "|" and the macro helped split up my data! Thank you!