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