Excel 2016 : Get & Transform - Add Column that include blank cell

Hi Guys/Ladies,

I'm new to Excel Get & Transform but not new to Excel.

Anyway, I needed to create a Unique Id with the available information on my sheet and I used " & " to join all the text.
Since I'm having about 500k row of data thus that get a bit sluggish which prompt me to use Get & Transform.

Here the issue I'm facing with Get & Transform when I used "& ". If any of my cells is blank, it returns a null on the new column but I still need the info even if is blank.

Is there anyway to resolve this in Get & Transform?

Thanks, Guys/Ladies