G
gordom
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
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