I am using Excel 2003 and have a question about taking a list of objects and filling those objects in other cells. I will get a list like this:

ID Animal Num
6000 Cat 3
7000 Dog 2
8000 Mouse 5

I want to be able to read the ID and the Animal and create a fill down in another part of the worksheet using the Num. What I want is below:

6000 Cat
6000 Cat
6000 Cat
7000 Dog
7000 Dog
8000 Mouse
8000 Mouse
8000 Mouse
8000 Mouse
8000 Mouse

Is there an easy way to do this?

Thanx in advance!!!