Joe G.

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?

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?