Thread: Sorting data based on product number

Hey everyone, I'm having a really big problem combining data from several cells based on a product number. Basically I have products that have multiple images and there listed out like this:

1|Image 1|
1|Image 2|
1|Image 3|
1|Image 4|
2|Image 1|
2|Image 2|
2|Image 3|
2|Image 4|

What I need is a way of combining the information from the image address cells with just a comma and a space in between the data. It must be based on the number in the cell in front of them which is the product number.

So that it looks like this:

1|image 1, image 2, image 3, image 4|

I think a macro can do it but I lack the knowledge on how to construct one of that complexity.

My description is confusing but if you look at the file uploaded you understand.


Any assistance would be very much appreciated!


Data Sorting Problem.xls

Originally Posted by JBeaucaire

"MERGE ROWS
Here's a macro for merging rows of data using the ID in column A and putting the column B values together in a delimited manner of your choosing. There's a sample file as well for testing.

Merge Rows

Thanks so much I appreciate this! It worked perfectly!!