When I copy multiple rows (name, address, city) from 3 cells into 3 merged
cells(in rows), I get name name name in the first line, and the same
repetitions in the second and 3rd lines. I've tried format, cell, center
across selection, but get the same results. When I copy just the name cell
to the merged cell, it works fine. I don't want to have to copy each of the
three cells and paste them individually. I want to select all three, and
paste them in the merged rows.

Any ideas how to work around this merged cell problem?