I'm trying to write a formula for the below requirement
If column 1 contains II then Column 2 = II
elseif column 1 contains III then column 2 = III
elseif column 1 contains IV then column 2 = IV
elseif column 1 contains JR then Column2 = JR
elseif column 1 contains SR then column 2 = SR
else null()
Column 1 | Column 2 |
IND II | II |
IND III | III |
IND IV | IV |
IND JR | JR |
IND JR | SR |
I got it figured out with the Regex match calc. Please ignore my ask
Hi @Idyllic_Data_Geek , do you mind sharing your solution here so that other's in the community can learn?
Thanks!