How to auto-fill in empty cells with first value til next value etc?
Can you please recommend a fastest (performance wise) solution on how to deal with the following.
I have this table with empty/null fileds - please see below - but I need that instead of those empty fields/nulls in Price column, the first Price column was filled in with the Price Value of the first Price Value till the next Price Value. Then after the next Price Value it was filled with the next Price Value til the next next Price Value etc.....
So it would look like this:
Any idea? Thanks in advance.
P.S. there is no any logic /patterns on how the Price changes.....