Combine data that spans two rows, preserving cells?
 

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

Combine data that spans two rows, preserving cells?
 

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...
--
~Anne Troy
www.OfficeArticles.com


"Bmuse" wrote:

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