Parsing a column

[GarMIngle]

Thanks for the help, I managed through trial and error to get what I think I need, 

I took things in various rows and concatenate them into one column ; such as

Office SuppliesFurnitureOffice SuppliesOffice Supplies 

Office SuppliesTechnology

Now I want to parse the long string as follows

Office Supplies,Furniture,Office Supplies,Office Supplies

Office Supplies,Technology

I want to use a Furniture and Technology in a formulae with another column.

[Qiu]

@GarMIngle 
A bit brutal, but is this working for you?

[GarMIngle]

Thanks for the info, I am using the RegEx tool. Almost there. Posted my before and after tool apllication.