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