Help

Un-nest imported data

Topic Labels: ImportingExporting
878 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Andrew_Malcolms
4 - Data Explorer
4 - Data Explorer

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 Reply 1
Matthieu_Rouvin
5 - Automation Enthusiast
5 - Automation Enthusiast

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…