I have no idea if that subject line makes any sense, but here’s what I’m trying to do. I have data in Grist that looks sort of like this (I think I’ve made it publicly accessible). Each row in the “thingies” table has a barcode column (simple text) and category column that is a reference list. I want to create a new “exploded” table where there is one row for each distinct combination of barcode and category. In other words, each row of the “thingies” table will generate N rows in the new table, where N is the number of references in the category reference list (see the “desired output” table in my example).
Can this be done in Grist?
I know I can whip up a stand-alone Python script to do this, but it seems a little crazy to be constantly exporting and re-importing. Or I guess I could do it with the API, but it seems like this is something that shouldn’t require that level of complexity…