I have excel doc where I have two columns "Tel" and "Mobile". Some records have only Tel and some have only Mobile while some have both, Now I want a single column where:
| A | B | C 2 | 200000000 | | HERE MUST BE 200000000 3 | | 700000000 | HERE MUST BE 700000000 1 | 200000000 | 700000000 | HERE MUST BE 700000000
If only Tel then put Tel
If only Mobile then put Mobile
If both then put Mobile
As you can see, the Mobile number is preferred over the landline Tel.
Now what query should I use? I used to do it with CONCATENATE(A1&B1) bu here if both columns have data I will get a non-sense number