google spreadsheet: join arrays using function NOT CODE

Question

I have one array

1 
2
3

another array

4
5
6

How do I use one function to join the 2 arrays?

1
2
3
4
5
6

Answer 1

Let's say your arrays are:

A1:A3 = {1;2;3} and B1:B3 = {4;5;6}

Write somewhere: ={A1:A3;B1:B3}

Semicolons ; are used to separate rows, and commas , are for columns.

Here is the documentation: Using arrays in Google Sheets