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
Bookmarks