Filling cells from a list

[conwa02976]

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!!!

[westconn1]

you can either loop through the list and build an array for each item, then add the array into a range, or else just use a for loop to put the item into that number of rows, just need to keep count so as to know which is the next row each time

[VBFnewcomer]

Are you trying to simply print the values in rows the no. of times as based on Num or trying to extract certain values from another location
if latter you may use VLOOKUP()