Parsing Structured Data into Multiple Columns in Excel

·

I'm trying to take structured data from one column and parse it into 6 new columns - basically people and titles, and move those to Person 1 Name, Person 1 Title, etc. I'm using a new column with a formula to try to make that happen but I cant seem to generate a prompt it can understand. Any better way to approach this?

3 comments

· Sorted by Oldest

kushagra t.
·
·
Is the Add Column not available as an option for the structured data in the cell?
kushagra t.
·
·
If it is a list of people in the cell - you might also want to explore moving the data to another table using write to enrichment. Each person will become a new row in the new table.
Joe G.
·
·
ill try that thank ya
1

Loading comments

kushagra t.
·
·
Is the Add Column not available as an option for the structured data in the cell?
kushagra t.
·
·
If it is a list of people in the cell - you might also want to explore moving the data to another table using write to enrichment. Each person will become a new row in the new table.
Joe G.
·
·
ill try that thank ya
1