Fill down Issue

[MUtasem]

Why Doesn't "Fill Down" Work When Trying to Fill Empty Rows with Data from Above

[Anonymous · Accepted solution]

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

[Omid_Motamedise · Accepted solution]

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 

[Omid_Motamedise · Accepted solution]

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 

[Anonymous · Accepted solution]

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

[mallorysteve]

I've tried this and still doesn't work to use Fill Down.

[mallorysteve]

Figured it out - has to be lower-case null not Null.

[MUtasem · Accepted solution]

I should trimmed text fist then replaced the value 

thank you for your support