How to Split column values into several columns

[jrod31]

I have a dataset that has company name and products in the same cell in a column. I need to split the company name and company products into its own column. 

Example:
Column Name is Product - and this entire text is inside 1 cell. 
Company Name¶Company Product¶ExtraTextNotNeeded

I was unable to do it with the Split column recipe. I might be doing it wrong.

Can someone help me or direct me on how to do this? 

Thanks, 

[JordanB]

Hi @jrod31,

You can try an unnest or unfold object/array step.

Let us know how it goes!

Thanks,

Jordan