1 of 1 people found this helpful
Have you tried using IFNULL() like the following
IFNULL([modified Sector], [sector_corrected])
and doing this for each one. If this doesn't solve your issue please post a packaged workbook
It worked! Thank you very much. I tried to use the formula before: If [modified sector]=" " then [sector corrected] END but it did not work.
Glad to help