Combine two columns without having duplicate data

Hello,   I need to combine columns, but I only want one value per column.   -If one column is empty, I want the value of the other in the new column. -If both columns are different I want one ...