Fill Dates

Question

Hi

I can do this in excel but im struggling in Alteryx

I have this data set like this

Essentially I want dates columns to be filled according to the corresponding date entered above.
I want the data to be like this

I have one big workbook in which the dates are not filled.

Please assist

Regards

CT

Raj · Accepted Answer

Go through multirow formula tool
in the example tab similar situation is been solved

IF IsNull([Date])
THEN [Row-1:Date]
ELSE [Date]
ENDIF

BRRLL99 · Accepted Answer

Use Multirow formula

and update in existing field