Fill the null cells to the value above

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

Developer

Developer Tools

Best Practices

Accepted answers

Christine_Assaad

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

All comments

Christine_Assaad

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

Please see the solution attached.

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

Good luck!

Hi all,

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

Thanks

FYI.

录制_2023_12_15_11_17_38_686.gif

salmansadatkarim

By any chance can you please share this workflow?

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703