Need help copying info from multiple rows to one cell....

Greetings,

New here - was pointed in this direction by Fortune 3 customer service for my Excel questions.

I have 2 sheets in the same workbook - one is products list, and one is product options.
The Product Options sheet contain a list of multiple products with individual colors and mostly identical product numbers of which they fall under.
What I want to happen is to use these product numbers as a reference to put the multiple colors in a single cell located in the Products List sheet.

Example:

Options
- #650 red
- #650 blue
- #650 Yellow

Products List
- #650 red, blue, yellow
(note the comma as well)

If done correctly, I can copy this code across all the products in the products list sheet so that each unique item number will have all their colors listed within a single cell.
I'm new to advanced Excel features, so I'm not sure if I should use something like VLOOKUP, and I have no idea how to use the macros, but I do have web programming experience if that will help.

Much appreciated

How is the information set up? As it is, I would say to use

=CONCATENATE(A1, ", ", A2,", ", A3)

If the three product codes were in A1 A2 and A3. It would help if you uploaded a sample sheet, though, because more than likely this is not exactly what you need...

Now is every product going to have exactly 3 colors or is it possible it is going to be variable?

Here it is if you'll always have 3 colors:

Please Login or Register  to view this content.

Thanks. But I should've made it clear that each product can have more or less than 3 colors. Some of them go as high up as 20 color variations!