| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate several rows
Hi All, this is the first time i have logged on. Please help me.
i have a list of 100 customers, where each customer has 1 or more phone numbers. the labels are - customer name(A1), Phone number (A2).... the phone numbers are in seperate rows... how do i concatenate such that i get the customer name in the first column and all his phone numbers (seperated by a comma) in the second column |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate many rows quickly | Excel Worksheet Functions | |||
| Concatenate info from columns into rows | Excel Discussion (Misc queries) | |||
| combining two rows of data into one (Not Concatenate) | Excel Discussion (Misc queries) | |||
| Concatenate multiple rows and columns into 1 cell | Excel Discussion (Misc queries) | |||
| How do I Concatenate these Dynamic Rows | Excel Worksheet Functions | |||
Threaded Mode
