View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gordom gordom is offline
external usenet poster
 
Posts: 14
Default 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