I appreciate this suggestion, but my hope was to move the value from row 2 to
row 1 and not just a formula. I need to export only one row per name and by
not having the actual data all in one row, doesn't allow that to happen.

"RyGuy" wrote:

Assume name and address is in Row1 and city/state/zip is in Row2, then:

B1 = =A1&" "&A2


Hope this helps...


"BobVanS" wrote:

I have an excel file that was created from some report writer and I have name
and address in one row, and city/state/zip in a second row. How can I append
the second row to the first? I can point to it with a formula, but really
want to move the actual value without doing a cut/paste for each row.