How to put data into an array?

[excelos]

Hello

I want to create an array with dynamic data (that is not a simple range), what is the best way to do that?

E.g. how can I create an array with A1:A5,A10:A15 ?

From my reading, it seems there are few ways, like creating a SEQUENCE first etc but what is the optimal and most flexible way?

Thanks!

 

[excelos]

thanks all, @bebo021999 is quite close to what I need, I used CHOOSE in the past, also SEQUENCE, but wondered what is the most flexible/capable way?

 

[Peter_SSs]

but wondered what is the most flexible/capable way?

How would we know when we do not know exactly what you want?
You said bebo is "quite close" but that implies that you actually want something a bit different. What is it that you actually want?

 

[excelos]

This collect A1:A5 and A11:A15 into a 2D array
=CHOOSE({1,2},A1:A5,A11:A15)
Then, for example, SUM:
=SUM(CHOOSE({1,2},A1:A5,A11:A15))

Book1
	A	B	C	D	E	F
1	1			#VALUE!		{1,7;2,8;3,9;4,10;5,11}
2	2			60
3	3
4	4
5	5
6
7
8
9
10
11	7
12	8
13	9
14	10
15	11
Sheet1

Cell Formulas
Range	Formula
D1	D1	=CHOOSE({1,2},A1:A5,A11:A15)
D2	D2	=SUM(CHOOSE({1,2},A1:A5,A11:A15))

Thanks, that's interesting that you can choose arrays instead of specific values! Is it possible to put the array one below the other than next to other?

 

[bebo021999]

Is it possible to put the array one below the other than next to other?

What do you mean?