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
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