Hi Excel Guru's 
I'm hoping one of you can help me with a macro in Excel 2007.
I have a row of data as follows on 'sheet1' with the word 'Dog' starting in cell A1.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Dog[/TD]
[TD]Cat[/TD]
[TD]Bird[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
What I am after is a macro that will on 'sheet2' list the data as shown below. I want the word to appear the number of times based on the value below it.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Dog[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Cat[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Cat[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Bird[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Bird[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Bird[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Bird[/TD]
[/TR]
</tbody>[/TABLE]
Any assistance would be greatly appreciated.
Gareth

I'm hoping one of you can help me with a macro in Excel 2007.
I have a row of data as follows on 'sheet1' with the word 'Dog' starting in cell A1.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Dog[/TD]
[TD]Cat[/TD]
[TD]Bird[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
What I am after is a macro that will on 'sheet2' list the data as shown below. I want the word to appear the number of times based on the value below it.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Dog[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Cat[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Cat[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Bird[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Bird[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Bird[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Bird[/TD]
[/TR]
</tbody>[/TABLE]
Any assistance would be greatly appreciated.
Gareth