Forum Discussion
Solved
Fill down Issue
Why Doesn't "Fill Down" Work When Trying to Fill Empty Rows with Data from Above
The values below have to be null, not blank or space. Just right click to copy the blank value, click replace values, replace with null. Then fill down.
--Nate
By using fill down, the null value (not blank cell) are replaced by the previous value, in your case, change your data type (or replace command) into text to change the blanck cell to null then use fill down
I should trimmed text fist then replaced the value
thank you for your support
I've tried this and still doesn't work to use Fill Down.
Figured it out - has to be lower-case null not Null.