Off the top of my head there are 2 options.
- You can either add a Group Loop that processes one Location at a time:
or
- you can use a Missing Value node after the Column Appender node, which is configured to apply the value from the previous row to any rows that have missing values:
Whether or not these will continue to work for you depends on your data. If you have a complex data set you should share it in the beginning.