Need help in joining two or more columns and remove few values from the final column

I had a data set with 10+ columns with different field values and null values. My usecase is to merge all the 10 columns and remove null values. Can refer the screenshot for the same.

Hello @cadit,

Not sure what you mean with remove null values, e.g. when you use concat

if the value of the field is null then it will not really show, see example below.

image

image