Fill the null cells to the value above

[Sshasnk]

I have a dataset where some of the rows is null and I have to put the value which is above

Input:

Field1

AXLSKDFI239848

ALSKC4839230

SLKCIV3847390

XLKDIEO384930

Output:

Field1

AXLSKDFI239848

AXLSKDFI239848

ALSKC4839230

ALSKC4839230

ALSKC4839230

SLKCIV3847390

XLKDIEO384930

[christine_assaad · Accepted solution]

Hi @Sshasnk 

Please check Multi row tool and the attached. Hope it helps. Cheers!

[Emil_Kos]

Hi @Sshasnk,

Please see the solution attached.

The multi-row is the perfect tool for a situation like this.

Good luck!

[tingho100]

Hi all,

Any way to apply this function to multiple columns without creating a lot of Multi row tool?

Thanks

[flying008]

@tingho100 

FYI.

[salmansadatkarim]

By any chance can you please share this workflow?