Transpose and create duplicate names

Excel 2007. Data is on sheet 1. Want a macro that goes down a list of names (over 100). There is only 1 unique name occurrence but data from multiple events are associated with that name in a horizontal manner. Want to copy name in R1C1 and data in R1C2...R1C10 to sheet 2, column R3C1,transpose, and create repetitive name associated with data. Then I want it to go to another range (in sheet 1) for the same name say R1C20...R1C30 and copy that data and transpose to sheet2 starting in R3C3.Then loop to end of name column. Example:

dog.... 12 13 14 15 16 45 76.... oct nov dec jan feb march april
cat.... 78 22 89 78 63.... oct nov dec jan feb
Mouse.... 32.... oct

Transposed to 3 separate columns

dog 12 oct
dog 13 nov
dog 14 dec
dog 15 jan
dog 16 feb
dog 45 march
dog 76 april
cat 78 oct
cat 22 nov
cat 89 dec
cat 78 jan
cat 63 feb
mouse 32 oct