Merge to columns

[samdahlr]

Hi,

I have two columns that are the same field, both Middle Name. The first column does not have every single row filled and the second column has every row the first column does not have and vice versa. I want to merge them to one filled column.
Any thoughts?

Thank you!

[hoyasaxa215]

Do the two columns ever both contain the middle name? Or is one always blank?

[samdahlr]

One column is always blank.