This simple example will clarify my problem:

title color weight amount
product1 yellow 12 3
product2 red 11 1
product3 green 6 2
product4 purple 14 4


title color weight amount
product1 yellow 12 1
product1 yellow 12 1
product1 yellow 12 1
product2 red 11 1
product3 green 6 1
product3 green 6 1
product4 purple 14 1
product4 purple 14 1
product4 purple 14 1
product4 purple 14 1

So the number of rows of each product match the value "amount" of each
product.
So if there are 3 yellow products, I have to make 3 rows of yellow product.

I'm using excel2003 but I'm also able to do this "row multiplication" with
2007 if it helps.

Thanks!