I would like to know if there is a way to do the following:

File #1

Product Key Count
Red/12 1000
Red/24 2000
Green/36 3000

File#2
Size Red Blue Green....
12
24
36

I have 19 colors, 3 sizes--I want to look at File#1 (this may have all 19
colors and 3 sizes, or 3 colors and 2 sizes listed by color/size) and fill in
the File #2 with amounts.

Any Help Please???