Records

[Babio1964]

Hello
I have a rather challenging issue on my hands. This is what I'd like to do. It's even hard to put into words so I'll get right to my example. (If necessary, I can explain why, but I have a good reason...lol)

Cell values --> A:1 "Cat" B:1 "4" This would be generated --->C:1 "Cat1" D:1 "Cat2" E:1 "Cat3" F:1 "Cat4"
Cell values --> A:2 "Dog" B:2 "3" This would be generated --->C:2 "Dog1" D:2 "Dog2" E:2 "Dog3"
Cell values --> A:3 "Pig" B:3 "5" This would be generated --->C:3 "Pig1" D:3 "Pig2" E:3 "Pig3" F:3 "Pig4" G:3 "Pig5"
Cell values --> A:4 "Rabbit" B:4 "1" This would be generated --->C:4 "Rabbit1"

in other words I already have the data in column 1 and 2, but I need to populate the columns to the right with dummy records based on the value in the 2nd column. Obviously the animal data above is an illustration, but I'm looking for a way to do this with other data. For the record, when all's said and done, I'll need to do this for 238,000 records in total, so you can understand why I'm going through the trouble of this rather tedious post.
Long story short, I'll need to get all these records I generated into one column, but first things first.
thank you for any help!!!!!

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/excel-questions/854514-records.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).