| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Individual record spans multiple rows | Excel Worksheet Functions | |||
| Displaying the same information every week in different cells and preserving data. | Excel Worksheet Functions | |||
| Combine Data from Multiple Rows | Excel Discussion (Misc queries) | |||
| How to combine multiple rows of text cells into one cell | Excel Discussion (Misc queries) | |||
| Combine data rows in Pie Chart | Charts and Charting in Excel | |||
Linear Mode
