Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to combine several successive rows into one cell
Hi everyone,
I have two columns filled with data. This is the example: Column A | Column B __________|_______________________ name A | description A - line 1 | description A - line 2 | description A - line 3 | description A - line 4 name B | description B - line 1 | description B - line 2 name C | description C - line 1 | description C - line 2 | description C - line 3 name D | description D - line 1 | description D - line 2 | description D - line 3 | description D - line 4 | description D - line 5 Column A consists of list of product names. Not every row in this column consist of data; there are several blank cells. Column B consist of products descriptions. Each definition is divided into several lines (rows). I would like to combine these separate lines of description into one cell. As the result I would like to get something like that: Column A | Column B __________|_______________________________________ _______ name A | description A - line 1, line 2, line 3, line 4 name B | description B - line 1, line 2 name C | description C - line 1, line 2, line 3 How can it be achieved? Thanks in advance for all your help. Regards, gordom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy row on 2+ w'ksheets and paste to successive rows on new w/sh | Excel Discussion (Misc queries) | |||
I am not able to extend formulas to successive rows | Excel Worksheet Functions | |||
Combining Totals on Successive Rows Based on Two Criterion | Excel Discussion (Misc queries) | |||
formula to apply concatenation to successive rows of data | Excel Worksheet Functions | |||
combine rows into one cell separated by comma | Excel Discussion (Misc queries) |