new column with values depending upon another column

38 Views Asked by At

I have a column "current stage" which can take values from 2 to 8.Based upon it my new column"possible stages" should have the values as 2 to current stage-1. For example: if "current stage" is 5, possible stages should be 2,3,4 .(in sequence)

if ""current stage" is 6, possible stages should be 2,3,4,5 .(in sequence)

0

There are 0 best solutions below