>>531822340
After a lot more work than I expected and some Google Sheets scripting I got all that effort to work out!
I'm beyond happy right now especially since I can move on to the rest of the cleanup. This is probably the most autistic spreadsheet project I've done.