Hi Guys,

I'm working on a large table which has one product number followed by all of its colors in the next few columns. I need to translate this into a table which has all of the Product# and Description info for in rows for each individual Color Name.

Attached is a small sample of the data and what it looks like before, and what I need it to look like after.


Thanks so much for your help in advance!

Andrey

excelforum1.JPGexcelforum2.JPG