Replacing blanks with previous value

Question

Hi Team,

Hope you are well.

I have an excel file like below marked in Red where we have blanks in between like a (Pivot). It needs to be replaced with the same value where it is blanks. Please see in Yellow.

Please let me know how to go about this,

Thanks

Sri

toask_alter.xlsx

FinnCharlton · Accepted Answer

Hi @sriniprad08 , you can use the Multi-Row Formula tool for this:

Have a look at the attached file for the tool configuration. Hope this helps!