I would like to have a formula in column C that would look at column A and
Column B and combine both entries . There are blanks where indicated.
A B C
Bob Bob
Jack Jack
Dick Dick
Nancy Nancy
Mary Mary

Can anyone help me?