Excel 2007 : Duplicate rows a given number of times

[kayell]

Hi

I have a file which is summarized showing a product id and the number of times it has been sold. i.e.

Date | Ad ID | Volume
12/12/2010 | abc1 | 2
12/12/2010 | abc2 | 4
12/12/2010 | abc3 | 1

I need to convert this summary back into a "batch" format i.e.

Date | Ad ID
12/12/2010 | abc1
12/12/2010 | abc1
12/12/2010 | abc2
12/12/2010 | abc2
12/12/2010 | abc2
12/12/2010 | abc2
12/12/2010 | abc3

Does anyone have any ideas how I can do this in Excel?

Many thanks!

[kayell]

I've found a fix for this. Thanks anyway!