A way to do this is with the Missing Value node. It allows the option to use the previous value for missing values. I used a simplified version of your example:
The node works perfectly. The problem I faced was due to fields having blank in them.
I replaced blank with null and then used the missing Missing Value node.
Thank you for your super quick response. Really appreciate it.