How to fill down with last non null value above in a field?

I have the following dataset

and I want to fill the empty cells (they're null in alteryx) with the last date value from above

to look like this

I have found answers on how to fill if the amount of gaps between dates are fixed(multi-row formula grab from above), but what about when they are variable?

Thanks for the help!

New Workflow1.yxmd

Transformation

Preparation

Accepted answers

Aaron_Harter

@colestauss - check out the first example of the Multi-Row Formula tool, which will dynamically fill down from above (from top to bottom) until the end of the data set:

Spoiler

All comments

Aaron_Harter

@colestauss - check out the first example of the Multi-Row Formula tool, which will dynamically fill down from above (from top to bottom) until the end of the data set:

Spoiler

colestauss

You're the man Aaron!

Ashutosh

Your Question served my purpose

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703