I have two spreadsheets, both with key columns. They have a parent-child relationship. The “key” column in the clipboard spreadsheet becomes a value in the “order” column in the delineatedLocations spreadsheet. All rows with the same value in the “order” column in the delineatedLocations spreadsheet correspond to each other in a group within the clipboard spreadsheet.
I’m trying to write a SELECT() statement that groups the rows according to whether or not they have the same value in the “order” column. Something like
SELECT(delineatedLocations[key],value in order column=value in key column in clipboards table)
How do I go about this?