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

 

[Comfy]

Here's a very quick way:

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Cat	4	Cat1	Cat2	Cat3	Cat4
2	Dog	3	Dog1	Dog2	Dog3
3	Pig	5	Pig1	Pig2	Pig3	Pig4	Pig5
4	Rabbit	1	Rabbit1
Sheet1

Cell Formulas
Range	Formula
C1	=IF($B1<(COLUMN()-2),"",$A1&COLUMN()-2)

 

[Babio1964]

Here's a very quick way:

Excel 2010

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
Cat	Cat1	Cat2	Cat3	Cat4
Dog	Dog1	Dog2	Dog3
Pig	Pig1	Pig2	Pig3	Pig4	Pig5
Rabbit	Rabbit1

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"]4[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]3[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]5[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]1[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C1[/TH]
[TD="align: left"]=IF($B1<(COLUMN()-2),"",$A1&COLUMN()-2)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Wow, not only did you understand my rather clumsy question, you gave me the solution and all within about 15 minutes
thank you!

 

[Comfy]

Wow, not only did you understand my rather clumsy question, you gave me the solution and all within about 15 minutes
thank you!

You're very welcome.