I have a data set with 4 columns - Original Bank , Acquiring Bank, Acquired Status ( Yes/ No) , Final Bank Name
Depending on whether the acquired status is yes or no, I want to copy the bank name to column Final Bank Name. Following rules apply :-
a) If the bank under column Original bank has...