I’m not sure if this is even possible but here it goes. I’m working on a timesheet problem. This is my first dilemma (I’m sure there will be more).

I’d like to copy the contents of cell A1 a number of times based the value in B1 and place the first one in cell A10, second in A11, third A12, etc.. Then copy the contents of A2 a number of times based on the value in B2 into the next available cell after A1 has been copied, then A3…B3.

Example:
A1 = dog
B1 = 2
A2 = cat
B2 = 4
A3 = mouse
B3 = 1

Results:
A10 = dog
A11 = dog
A12 = cat
A13 = cat
A14 = cat
A15 = cat
A16 = mouse

Any help would be greatly appreciated.

Thanks,
SKK