Copy from cell above in Alteryx

[keithr197]

Hi Everyone 

I have a dataset as per below. I need the column to populate (like the F5 function in excel) based on the cell above, is there a way in alteryx that i can do this?

[DataNath]

Hey @keithr197, you can use a Multi-Row Formula for this like so:

[keithr197]

Hi @DataNath 

Thanks for this, this definitely answers part of my question, when I follow your example the word region copies through out the data set. I need regoin to copy to rows 2 and 3 and Eastern cape from rows 5 etc. There are multiple rows with data and Nulls inbetween 

[DataNath]

Ahh okay sorry @keithr197, thought you were just filling down a single value from your original screenshot. Try the following instead:

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

Keep the rest of the configuration the same as I have it in mine.