HI,

I have a simple dataset with a column containing flags. What Im looking to do is where this flag exists, mark the previous row eg:

Screenshot 2021-07-01 at 10.07.07.png

So where there is a '1' in column B, place a 'Y' in column 'C' for the previous rown.

Many thanks,

Fiorano