How to copy only non-blanks to the parallel column by retaining the cell positions?

[papusale]

In the attached workbook, I have a list of two emails (each gathered from a different source).
Now what I would simply like to do, is move all the content from "Email 2" (E column) to "Email" (D column), however without replacing the content of D column with blanks included in E column.

Long story short, I would like to combine all the entries' corresponding emails in one column.

Thank you in advance!

[bebo021999]

Use column F to combine:

F2=D2&E2

Copy / paste value back to D column

[papusale]

Use column F to combine:

F2=D2&E2

Copy / paste value back to D column

Worked like a charm! Thank you very much. Never knew it would have been a formula this simple!