I have a row of data that looks like this
1,2,3,4,<null>,<null>,5,<null>,6,7,<null>
where new data is added each week to a new column whenever it is available. How do I find the last value in the row such that intermediate null values do not cause errors or incorrect values?
1,2,3,4,<null>,<null>,5,<null>,6,7,<null>
where new data is added each week to a new column whenever it is available. How do I find the last value in the row such that intermediate null values do not cause errors or incorrect values?