Translate Row W/ Product# And All Colors To Product# W/ 1 Color Per Row (Images included)

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

I'm guessing I might need to use a Pivot Table for the larger data group. Am I on the right track?