Fill in Null values with the cell below

[cindyoliviaa]

 

Hi all,

I'm trying to populate the Null values with the cell below that has a value (see screenshot for input and intended output). However, whenever I tried it would only update the cell above the actual value instead of populating all the null values before it.

Thanks!

 

[Qiu · Accepted solution]

@cindyoliviaa 

Something like this?

[cindyoliviaa]

Hi @Qiu 

Sorry I should've separated the picture. I only have the input, and I'm trying to make it look like the Output column.

[Qiu]

@cindyoliviaa 

What you are looking at is the output, and the input is like this.
Kindly download the workflow and run to see.

[cindyoliviaa]

You're right sorry, I had quickly glanced at the formula and misread your solution. Thank you very much!! @Qiu 

[Qiu]

@cindyoliviaa 
Its alright. 

Glad to help and thank you for the accept mark,😁