Thaks all for the help.

It's works great! Now can I ask more?

Sorry for not adding them all in once - just try to make it simple for myself 🙂

Col1, Col2, Col3 Col4, Col5

1 2 Val_A, Val_B, Val_C

1 2 Val_D Val_B, Val_E

1 2 …..

2 2 …

2 2 …

Now I want to modify the Col2 base on the Col4’s value(Bal_B)

So it would be like this:

1 2 Val_A, Val_B, Val_C

1 2 Val_D Val_B, Val_E

1 2 …..

2 2 …

2 2 …

3,Val_B,Val_A,Val_B,Val_C

3,Val_B,Val_D Val_B,Val_E