Array of repeatn

[kcmuppet]

[I accidentally hit some keystroke which posted this post before I was ready, so can't seem to edit the subject. Anyway, in case you're somehow reading this post...

How can I achieve what the formula in E23 is doing, more simply?

i.e. repeat the number in E20, the number of times given in the cell below, then the number in F20 repeated the number of times in the cell below, and so on (I have about 30 columns).

CBC2 Conjoint Simulator v0-1.xlsx
	E	F	G	H	I	J	K	L	M
20	1	2
21	6	3
22
23	1	1	1	1	1	1	2	2	2
Lists

Cell Formulas
Range	Formula
E21	E21	=COUNTA(tb_Attribute1_levels[Attribute1_levels])
F21	F21	=COUNTA(tb_Attribute2_levels[Attribute2_levels])
E23:M23	E23	=HSTACK(SEQUENCE(1,E8,E7,0),SEQUENCE(1,F8,F7,0))
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
Attribute1_levels	=tb_Attribute1_levels[Attribute1_levels]	E21
Attribute2_levels	=tb_Attribute2_levels[Attribute2_levels]	F21

 

[Fluff]

Any chance you could explain exactly what you are after.
Rather than posting meaningless formulae that look at cells you haven't shown.

 

[kcmuppet]

Any chance you could explain exactly what you are after.
Rather than posting meaningless formulae that look at cells you haven't shown.

I accidentally hit some keystroke which posted this post before I was ready, and now can't seem to edit the title....

 

[Fluff]

Just post an explanation of what you are trying to do.

 

[dreid1011]

Maybe this if you're using 365, will not work on 2010:

Book1
	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
20	1	2	3	4
21	6	3	2	5
22	1	1	1	1	1	1	2	2	2	3	3	4	4	4	4	4
Sheet1

Cell Formulas
Range	Formula
E22:T22	E22	=LAMBDA(val,rpt,TRANSPOSE(XLOOKUP(SEQUENCE(SUM(rpt)),HSTACK(1,SCAN(1,rpt,LAMBDA(a,b,a+b))),HSTACK(val,""),,-1)))(E20:H20,E21:H21)
Dynamic array formulas.

 

[kcmuppet]

Many thanks, it works! My first sight of the Scan function. I'm going to try to work out how it works and how to make the last part dynamically extend to the number of non-blank cells in rows 20 &21

 

[dreid1011]

Many thanks, it works! My first sight of the Scan function. I'm going to try to work out how it works and how to make the last part dynamically extend to the number of non-blank cells in rows 20 &21

You're welcome, and happy to help. I got it from here:

and learned most of it while I was at it. It is explained quite well. I added the TRANSPOSE and used HSTACK instead because of your data layout.