Combining multiple columns in an organized way

I am compiling data into a metadata file. I would like to combine all columns into one combined column by concatenating or some other formula. However, some columns I want to concatenate are "N/A", w...