Multi Rows? Needing to change the value of all subsequent rows if a value occurs

Question

I have a set of data that whenever a certain value occurs (the value is "NNN"), I need all subsequent values in the column to change to "NNN". One additional complexity to this is that I need it to only apply the "NNN" to the remaining values within it's "group". Below is an example of my data and what I'm needing the desired output to look like (see "Needed Output" column).

I have a feeling I should use the multi-rows tool for this, but I am at a complete loss for how to go about writing the workflow. Any help is appreciated!

Sample Data.xlsx

AbhilashR · Accepted Answer

Hi @aamerin, could you give the attached solution a try and let us know if the approach is satisfactory. My multi-row formula looks something like:

IF [VALUE] = 'NNN' 
	THEN [VALUE]
ELSEIF [Row-1:OUTPUT] = 'NNN' 
	THEN [Row-1:OUTPUT]
ELSE [VALUE]
ENDIF

I hope this helps!