How to get a spill of multiple SEQUENCES side-by-side, based on an input array {n1,n2,etc.}?

[Rnkhch]

Hello,

Suppose I have the following expression to generate a sequence:

=LET(n,3,SEQUENCE(6,,n,1))

which generates {3;4;5;6;7;8}

Now, what if n was an array itself, like this {3,4} or {3;4}? How can I make the LET expression =LET(n,{3,4},SEQUENCE(6,,n,1)) or =LET(n,{3;4},SEQUENCE(6,,n,1))
generate a side-by-side spill of the following array:

{3;4;5;6;7;8,4;5;6;7;8;9}

I tried MAP, but I got the nested array not supported error.

I would appreciate any input!

Blank power workbook1
	A	B	C	D	E	F	G	H	I	J	K	L
1
2		3		3	4		3			#CALC!
3		4					4
4		5
5		6
6		7
7		8
8
9				desired output			desired output			desired output
10				3	4		3	4		3	4
11				4	5		4	5		4	5
12				5	6		5	6		5	6
13				6	7		6	7		6	7
14				7	8		7	8		7	8
15				8	9		8	9		8	9
16
Sheet1

Cell Formulas
Range	Formula
B2:B7	B2	=LET(n,3,SEQUENCE(6,,n,1))
D2:E2	D2	=LET(n,{3,4},SEQUENCE(6,,n,1))
G2:G3	G2	=LET(n,{3;4},SEQUENCE(6,,n,1))
J2	J2	=LET(n,{3,4},MAP(n,LAMBDA(n,SEQUENCE(6,,n,1))))
Dynamic array formulas.

 

[ISY]

Hi

=LET(n,3,k,SEQUENCE(6,,n,1),CHOOSE({1.2},k,k+1))

 

[JvdV]

Have a go with:

=DROP(REDUCE(0,{3,4},LAMBDA(a,b,HSTACK(a,SEQUENCE(6,,b)))),,1)

Or a bit simpler:

={3,4}+SEQUENCE(6,,0)

 

[Rnkhch]

Wow , those are very interesting ways of using SEQUENCE! Thank you both!

(Thinking of your solutions raised another interesting question in my mind, which is how to intercalate multiple SEQUENCEs, which I'll post separately.)

 

[Rnkhch]

Building up on this, how can the "step" be incorporated in the SEQUENCE as the same array of numbers (in this case {3,4}), such that each column gets its respective step, as below:

Blank power workbook1
	A	B	C	D	E	F	G	H
1
2						desired output
3		3	4			3	4
4		4	5			6	8
5		5	6			9	12
6		6	7			12	16
7		7	8			15	20
8		8	9			18	24
9
Sheet1

Cell Formulas
Range	Formula
B3:C8	B3	={3,4}+SEQUENCE(6,,0)
Dynamic array formulas.

I tried putting the {3,4} for the step, but it didn't work.

 

[Fluff]

How about

={3,4}*SEQUENCE(6)

 

[Rnkhch]

Awesome, thanks! Another great SEQUENCE trick!

 

[Fluff]

Glad to help & thanks for the feedback.