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
Create a simple formula to concatenate textPress = (the equal sign). Click the first cell that you want to refer to in the join and then press + (the plus sign). Click the second cell that you want to refer to (to join the values together) and press Enter.
Merge columns vertically with an array and semicolonUse an array ( {} ) with a semicolon ( ; ) as a separator to merge column ranges. As an example, we'll use a dataset imported from Airtable to Google Sheets.
To use it in Google Sheets, you can either directly type “ARRAYFORMULA” or hit a Ctrl+Shift+Enter shortcut (Cmd + Shift + Enter on a Mac), while your cursor is in the formula bar to make a formula an array formula (Google Sheets will automatically add ARRAYFORMULA to the start of the formula).
Appends strings to one another.
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With