I am working with database files where the primary first name, secondary
first name and primary last name and secondary last name are in separate
columns.

What I need is a formula the will concatenate the Primary first and Primary
last with an "&" sign inbetween if the primary last and the secondary last
are the same or the cell is blank.