Un-nest imported data

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

1 Like

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…