Hi all,

I have inherited a spreadsheet containing "records" that are split over two
rows. For example:

A B C D
E F G
John Doe 123 Anystreet
Dallas TX 12345
Chess Club (212) 555-1212

I need to end up with one row, separate cells, for each "record" -- so I can
create proper column labels, and export a CSV to contact mgmt software.

Googling things like "combine merge rows Excel" comes up with mostly links
to commercial software. I've tried the "Merge and Center" button, but the
data in both rows just disappears.

My spreadsheet contains thousands of 2-line records. Manual cut-and-paste
isn't really feasible.

Can anyone help?

Many thanks,
Bmuse