Forum Discussion

MUtasem's avatar
MUtasem
Frequent Visitor
1 year ago
Solved

Fill down Issue

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

 

  • Anonymous's avatar
    Anonymous
    1 year ago

    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 

  • MUtasem's avatar
    MUtasem
    1 year ago

    I should trimmed text fist then replaced the value 

    thank you for your support 

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

    • MUtasem's avatar
      MUtasem
      Frequent Visitor

      I should trimmed text fist then replaced the value 

      thank you for your support 

  • 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