LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy row on 2+ w'ksheets and paste to successive rows on new w/sh Joe 127305 Excel Discussion (Misc queries) 1 March 8th 08 07:59 PM
I am not able to extend formulas to successive rows jrich15322 Excel Worksheet Functions 4 October 16th 06 01:43 PM
Combining Totals on Successive Rows Based on Two Criterion razorsharpe Excel Discussion (Misc queries) 1 August 18th 06 03:24 PM
formula to apply concatenation to successive rows of data Devo Excel Worksheet Functions 2 July 24th 06 05:42 PM
combine rows into one cell separated by comma Miki Jo Excel Discussion (Misc queries) 2 March 9th 06 08:22 PM


All times are GMT +1. The time now is 10:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"