View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sarah (OGI) Sarah (OGI) is offline
external usenet poster
 
Posts: 128
Default Transposing data?

I have a list of 820 customer ID's in column A. Some of these are duplicates
though, because each customer can have up to four business categories, ME,
CL, PP, PB (which are shown in column B). For example:

Customer ID Policy Type
0001 ME
0001 CL
0002 CL
0002 PP
0002 PB
0003 ME
0003 CL

Is there any way of listing unique customer ID's and in the corresponding
cell(s) show the relevant business categories along the same row. I say
'cell(s)' because they can each go into separate cells along that row or be
grouped together in one cell. Results should look like the following:

Customer ID Policy Type
0001 ME CL
0002 CL PP PB
0003 ME CL

Thanks in advance.