How to combine multiple rows of duplicate data and one cell of unique data

I have a customer list of over 7000. In columns A-J, lists the customers information and in column K the type of product. There are rows with duplicate customer information (up to 12 rows) because of the different products in the last column.

I would like to have a list that combines the duplicate customer information into a single row and lists the different products in one cell separating each with a comma.

Is there an easy way I can do this? I'm having such a hard time and I also looked in the forum for the equation but was unsuccessful.

I appreciate the help in advance!
Sample-Data.xlsx

Look at the 3rd posting in this thread

http://www.excelforum.com/excel-form...e-results.html

Install the vba UDF and run it. Then do a delete duplicates from the ribbon.

You need a VBA UDF (User Defined Function) to do this.

Are you familiar with using macros?

With your file open...

Press the key combination of Alt+F11 to open the Visual Basic Editor

Goto the menu Insert>Module

Copy the VBA code below and paste it into the window that opens on the right side of the screen

Press the key combination of ALT+Q to close the Visual Basic Editor and return to Excel.

Please Login or Register  to view this content.

Then, in your file...

Enter this array formula** in cell K18:

=concatall(IF(B$2:B$12=B18,K$2:K$12,""),",")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy down as needed.

P.S.

If you're using Excel 2007 or later you'll have to save the file as a macro enabled file in the *.xlsm file format.

Here's your file with this implemented:

Sample Data(1).xlsm

You're welcome. Thanks for the feedback!