Conditional row fill

If I am wanting to fill a new column based on the value of an adjacent column. Appreciate any suggestions:
Input:
MyTransform.transform (1.2 KB)
Output required:
Screenshot 2022-07-07 at 12.07.31

Many Thanks Robert

Hi,

I cannot add transform file as attachment at the moment, because I am new user

So, I have uploaded the transform file on file share server the link is as follows

1 Like

Many thanks - much appreciated

Here is an alternative approach using Javascript instead of a Lookup.

rbTransform.transform (2.7 KB)