Formula to repeat cells

[natlmc4877]

I have a spreadsheet with order numbers and email addresses. I need a formula to show.

Etc - If number in cell c2 is 2, copy cell b2 once and paste to cell f2
If number in c2 is 3, copy cell b2 twice etc.

Thanks so much!

 

[Cubist]

Is this what you mean?

Book1
	A	B	C	D	E	F	G
1	order_number	email	quantity
2	KX6ZK	test@email.com.au	4			test@email.com.au
3						test@email.com.au
4						test@email.com.au
Sheet2

Cell Formulas
Range	Formula
F2:F4	F2	=IFERROR(EXPAND(B2,C2-1,,B2),"")
Dynamic array formulas.

 

[natlmc4877]

Yes, kind of. But in row f i need it to list them all.

 

[Cubist]

Ok, try:

Book1
	A	B	C	D	E	F
1	order_number	email	quantity
2	KX6ZK	test@email.com.au	2			test@email.com.au
3	XGJGO	test2@email.com	1			test3@email.com
4	ABCDF	test3@email.com	5			test3@email.com
5						test3@email.com
6						test3@email.com
7
Sheet2

Cell Formulas
Range	Formula
F2:F6	F2	=TOCOL(IFS(C2:C4>SEQUENCE(1,MAX(C2:C4)-1),B2:B4),2)
Dynamic array formulas.

 

[natlmc4877]

not quite working (i have changed the font to wingdings as it is email addresses)
keeps saying #CALC!

 

[Cubist]

It's a single formula. Grab the entire range. Clear everything below. See the post#4 again.

 

[natlmc4877]

Thank you so much! it worked perfectly