Un-nest imported data

[Andrew_Malcolms]

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

[Matthieu_Rouvin]

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…