Hi-- I can't figure out how to write a script that imports an Excel worksheet with a sub summary layout while filling in missing data. I would like to import the data and fill in the ID numbers in their associated row (i.e. copy 78900 up to 987650, then copy 987650 up to 543980, etc). It's a large excel worksheet with lots of codes associated with IDs, so I'd prefer to not do it in Excel.
Any help is greatly appreciated
It looks like this: