hi,
i would like to perform some operation as described below but do not know how to do it, any guidance is greatly appreciated, thanks:

Please Login or Register  to view this content.
If A2=B1, shift the whole row 2 values to the right.(move A2 value to B2, B2 to C2, C2 to D2...etc)
If A3=B2, shift the whole row 3 values to the right.(move A3 value to B3, B3 to C3, C3 to D3...etc)
....
The above example expected result is this way:
Please Login or Register  to view this content.