Hi, I have a set of data, Column A Consist of Fleet name and Column B Consist of Registration Number of the Fleet. Some of the registration are not recorded.
I want to say that if there is no record in column B take the name in column A.
Reason for wanting to use column b is that as these are official fleet registration they are more accurate than fleet names which sometimes can have duplicates
