TheLostBoy
Solid State Member
- Messages
- 17
I've got a good-sized single sheet workbook (A1:I8851) that I need a fairly complicated (seems like it to me, anyway) macro to get data in line from column to column. Here's what I've got:
Column A is titled "Category", and Column D is "Description". The actual category listings are in merged cells, spanning anywhere from 5-12 rows. Column D has no merged cells, but many cells in D contain data carried over from the cell above it (instead of wrapping the text, for some reason it just inserted into a new cell).
I need a macro to combine each of the multiple rows in D into one single row, stopping and starting over when it reaches the next Category row. That way each category will have a single description line without incorporating parts of the description from the category above or below it. Does that make sense?
Column A is titled "Category", and Column D is "Description". The actual category listings are in merged cells, spanning anywhere from 5-12 rows. Column D has no merged cells, but many cells in D contain data carried over from the cell above it (instead of wrapping the text, for some reason it just inserted into a new cell).
I need a macro to combine each of the multiple rows in D into one single row, stopping and starting over when it reaches the next Category row. That way each category will have a single description line without incorporating parts of the description from the category above or below it. Does that make sense?