Combine two columns without having duplicate data

Question

Hello,
&nbsp;
I need to combine columns, but I only want one value per column.&nbsp;&nbsp;-If one column is empty, I want the value of the other in the new column.
-If both columns are different I want one column to have priority, in the example Column A.-If both columns are the same, I want the value to appear only once.
&nbsp;
Example
A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A
John.doe@gmail.com&nbsp; &nbsp; john.doe@hotmail.com&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;John.doe@gmail.com
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Joe.doe@outlook.com&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; joe.doe@outlook.com
jack.doe@hotmail.com&nbsp; jack.doe@gmail.com&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; jack.doe@hotmail.com
&nbsp;
Who wants to save the day and help me with this?
Cheers.

sergeibaklan · Accepted Answer

Hi Alexander,
&nbsp;
Do you mean
=IF(LEN(A1)=0,B1,A1)
?

Forum Discussion

Combine two columns without having duplicate data

Share

Resources