Replacing blanks with previous value

[sriniprad08]

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

[FinnCharlton · Accepted solution]

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!

[sriniprad08]

Hi @FinnCharlton ,

thank you so much. It worked perfectly. Appreciate your time and support.

Cheers,

Sri