Excel Formula

[ARMORTANKER]

Hello all

Im trying to create a formula for my business spreadsheet.

I need a formula to match the number of sold items in another column.
Example Column B says 2 Sold of this particular item quantity, I need column C to match column B and say *German,*German and so on and so forth down the column. This will keep me from having to manually enter the data. Any ideas would be great.

 

[JGordon11]

Book2
	A	B	C	D
1	Quantity	ID	Repeated
2	2	AAA	AAA,AAA
3	3	BBBB	BBBB,BBBB,BBBB
4	4	CCCCC	CCCCC,CCCCC,CCCCC,CCCCC
5	5	DDDDD	DDDDD,DDDDD,DDDDD,DDDDD,DDDDD
6
Sheet1

Cell Formulas
Range	Formula
C2:C5	C2	=TEXTJOIN(",",1,IF(SEQUENCE(A2),"") &B2)

 

[ARMORTANKER]

Great work! One issue. For the multiple one item orders is just returns a #value!, how can I make that just keep the original?

 

[JGordon11]

Book2
	A	B	C	D
1	Quantity	ID	Repeated
2	2	AAA	AAA,AAA
3	3	BBBB	BBBB,BBBB,BBBB
4	4	CCCCC	CCCCC,CCCCC,CCCCC,CCCCC
5	5	DDDDD	DDDDD,DDDDD,DDDDD,DDDDD,DDDDD
6	1,1	EEEE,EEEE	EEEE,EEEE
7
Sheet1

Cell Formulas
Range	Formula
C2:C6	C2	=IFERROR(TEXTJOIN(",",1,IF(SEQUENCE(A2),"") &B2),B2)

 

[ARMORTANKER]

Thank you so much JGordon11.. Life saver