Need help with CONCAT Function

Hi All,   Need help here with CONCAT Function, as I need to concat column A and B and get values as am getting for Rows 2 and 4 but for cases like in Row 3 where I have blank results, then I ...