Extract parent for child based on ordered list reference

Hello everyone,   I have a table that has an ordered list reference which I would like to convert into a flat hierarchy to use in filters. However, I'm stuck on how to extract the parent for each c...