How to Split column values into several columns

jrod31
jrod31 Registered Posts: 14

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,

Answers

Setup Info
    Tags
      Help me…