Combine data from multiple rows into one row when other column data changes

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

It's perfect. Thank You Sooooo much!

Hello Again,

I have the same spreadsheet of customers and their program data and need an adjustment to the code previously provided. As stated many customers have more than one program and each program may also have different renewal months. 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,FS,MC. Multiple renewal months would also be separated with a comma and in the order they were originally in by program. If all renewal months are the same for all programs in each customer record then only one month would show in the Renewal column after the rows are merged.

The help I received last time was a time/life saver. I hope someone can crack this one too.

Thank You!

JBeaucaire thank you so much for your help. The code works but seems to have a small glitch. If we can get that fixed it would be perfect.

For customers who have different programs but all the programs have the same renewal months in the "Renewal" column it would be great if it would just show that one renewal month instead of two identical dates divided by the comma.

For example: Pamela Anderson has two programs and they both have a renewal of 7/31/2013. With this code shows the renewal column for Pamela as "7/31/2013, 7/31/2013" instead of only "7/31/2013" since both programs have the same date.

Is that possible to do?

Thanks Again

That sounds ligical. However, I also want to use the data to identify when different programs for the same customer have different renewal months. In this case I wouldn't really care which renewal goes with what program only that there are different renewal months for the same customer. So I can use the first code for my main purpose and if you are able to do the other tweak I can use that code for my second purpose. That would make it easier. Again, thank so much for all your help .