There is a simple solution for your issue which is to use “coalesce” function
coalesce ( arg , arg ) Returns first non-empty value of the two arg s. Returns an empty string if both are empty or non-existent.
Kindly see the example:
Coalesce_example.xlsx (11.4 KB)
Let me know if you have any question.
Best,
Yasser
