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!
Solved! Go to Solution.
@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:
You're the man Aaron!
Your Question served my purpose