Fill empty cells with the the information from the row below!!

Question

I am trying to populate the empty cells with the cell before it. How can I do that?

Thanks!!

Before:

After:

IraWatt · Accepted Answer

Hey @AmAm,

What you need is a multi row formula like this:

If you look at the tools configuration window, it updates my test column. In the formula it checks if the current column is empty then use the value of the row above. If you have any questions feel free to ask. If this answers your question give it a tick :)

All the best,

Ira

binu_acs · Accepted Answer

@AmAm This can be done with the help of multirow formula tool. Here are two ways of doing it