I have an issue with filling null values in the table.
Please find attached sample document with a QVD file for information. As you can see there are some null values against date and divisions.
I want to put the previous value (for null value fields)against the division until the next available value in the table. The reason is I need to record a value every single day from the start date to finish date for every single location. If there is no values against a division, I want to pick up the previous value against the division