I'm trying to assign GL account numbers based on what is contained in the row above a specific line. See screenshot for example, I've scrubbed my company's info out of it but the premise is the same. The first table shown is the current state of my workflow and the second table is what I'm trying to do. I need to change the GL column of the [Null] rows to specific GL accounts based on the GL account above it. For example, "if the above row's GL column is '123.2' then '361.1'" and on and on until all the [Null] rows have a GL column identifier assigned.
