Hi,

I have a large spreadsheet of customers and their program data. Many customers have more than one program. Each program is on a separate row with the customer's information being repeated for each row.

The attached example (sheet1) shows one set of data in it's existing form with one row of customer information for each program they have, whether it is one program or more.

The next set of data on the same attachment (sheet2) shows what I would like to be my resulting data. That being, each customer having one row of data and their program or programs in one cell of the customer's row of information. Multiple programs would be separated with a comma and listed in this order: CW,CF,MC.

I used celebrity names in my sample worksheet, just for fun.

Any help would be greatly appreciated!

Sample Worksheet.xlsx