Thread: Duplicate rows a given number of times

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!