Skip to main content

I’m importing data from a CSV with a nested appearance like this:




































Food Group Food
Fruit bananas
apples
oranges
Veg kale
squash
Cauliflower

I need to flatten the nesting to look like this:




































Food Group Food
Fruit bananas
Fruit apples
Fruit oranges
Veg kale
Veg squash
Veg Cauliflower

Presently I’m using a complicated formula in Google Sheets before importing. Can this be done in Airtable instead?


Thanks very much

This use case is quite common. Many exports of databases are flattened and importing a csv file generated from a flattened database would be very useful.


I would love to read a solution to Andrew’s question…

Reply


Terms & Conditions