Consolidate data from multiple rows to one cell separated by comma.

Hi All,

Slightly complicated to explain my issue but please see sample data attached.

I basically have products in my store which fit specific vehicles, where each vehicle has a unique code (in this example a 3 digit number). I have a list of over 330,000 rows with just part number in column A and the vehicle code in column B. The part numbers are duplicated as many times as there are vehicle codes listed for it. I need to consolidate all of the vehicle codes that fit the one part number, to one cell with each code separated by commas in order to import that field to my system.

Some part numbers might fit many vehicle codes (hundreds), so it is not something I want to be doing manually!

I would be fairly handy with excel as I use it every day to add products to my system and website and analyse business data etc but just not sure where to start here! Any help much appreciated.

Thank you! Works great, although my system is not able to handle it very fast so I am splitting the data up into around 23 files of 15,000 lines each..!

You did not mention that. I found a great solution to overcome this types of solutions here: https://stackoverflow.com/questions/...es-in-column-a
Try this one:

Please Login or Register  to view this content.