I need to loop through a table to change values depending on what is in the column.

Question

I would like to designate all values in my designation field to be N26 until the records hit "RELOCATIONS" in my New Stores field. Then I would like to change the values to start showing R26 in the designation field. I am using the Multi-Row formula tool to do this.  Once it hits any other text value I would like it to keep the designations null.  If possible I would like not to do any batch macros.

So my example table would look like this:

New Stores Designation 1 2 Swing 1 2 Relocations 1 2 Closure 1 2

My end result would look like this

New Stores Designation 1N262N26Swing 1N262N26Relocations 1R262R26Closure 1 2

Raj · Accepted Answer

@Bearcatrunner 
please find the workflow attached