Hi Team,
I have three columns named as 'B Name', 'B Chain' and 'B Add'. I want if my column 'B Add' contains 'Hotel 24' then my B Name and B Chain value should change to 'Ridge world; and rest value should remain the same. Please refer table below:
B Name | B Chain | B Add |
Creta | Creta | Hotel 24 |
Creta | Creta | Hotel 24 |
Creta | Creta | Hotel 25 |
Creta | Creta | Hotel 24 |
Creta | Creta | Hotel 27 |
Creta | Creta | Hotel 24 |
Creta | Creta | Hotel 24 |
Creta | Creta | Hotel 24 |
Creta | Creta | Hotel 30 |
Creta | Creta | Hotel 30 |
Creta | Creta | Hotel 30 |
Creta | Creta | Hotel 32 |
Creta | Creta | Hotel 32 |
Creta | Creta | Hotel 24 |
Solved! Go to Solution.
Perfect
Thanks