Combine data that spans two rows, preserving cells?

G

Guest

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 (e-mail address removed)

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
 
G

Guest

Please give us TWO records worth of data and tell us what is in each cell.
Trying to lay it out like columns here just doesn't work and we can't figure
out what your data looks like...
 
Top