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