How to Parse Structured Data into Multiple Columns in Excel

Joe G. · 2025-04-29T19:28:40.67957+00:00

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?

To parse structured data from one column into multiple new columns, you have a couple of options: 1. Using AI formulas: • Add a new column • Choose "Ask question about items with AI" from column options • Use the formula option to specify the data you want to extract for each new column (e.g., Person 1 Name, Person 1 Title) 2. Merge columns: • Click "Add column" > "Merge columns" • Select the appropriate data type • Write a formula to extract the specific information you need For complex parsing, you might need to create multiple columns and use separate formulas for each. If you need further assistance with formula creation, please request human support by clicking on "Talk to a person".

Sources: Hide, Re-order, Sort, Filter, Merge Columns Table columns | Documentation | Clay University

1 comment