core.noscript.text
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
Multi Row Formula - IF [Data]=Null() THEN [row-1:Data] ELSE [Data] ENDIF
Without knowing more about the data itself, this would be the general statement I'd use!
Thanks for you're quick reply, it doesn't seem to like that formula. Please see below.
The data is configured a V_String.
As mentioned, you need a Mutli Row Formula tool - completely different tool than the Formula tool! Multi-Row Formula Tool (alteryx.com)
Apologies, worked perfectly! Thanks Alex
Great news! Make sure to mark the most helpful response as a solution so others can see which was most helpful. Thanks in advance!
