FIlling in Empty Values

[Alexgray25]

Hi,

I am trying to fill in empty values I have in a column with the value above the empty cell.

Do you know which formula may achieve this?

Thanks

Alex

[alexnajm]

Multi Row Formula - IF [Data]=Null() THEN [row-1:Data] ELSE [Data] ENDIF

[alexnajm]

Without knowing more about the data itself, this would be the general statement I'd use!

[Alexgray25]

Thanks for you're quick reply, it doesn't seem to like that formula. Please see below.

The data is configured a V_String.

 

[alexnajm]

As mentioned, you need a Mutli Row Formula tool - completely different tool than the Formula tool!  Multi-Row Formula Tool (alteryx.com)

[Alexgray25]

Apologies, worked perfectly! Thanks Alex

[alexnajm]

Great news! Make sure to mark the most helpful response as a solution so others can see which was most helpful. Thanks in advance!