Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

google spreadsheet: join arrays using function NOT CODE

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 
like image 627
jason Avatar asked Jul 26 '13 15:07

jason


People also ask

How do you use the join function in Google Sheets?

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.

How do I merge two arrays in Google Sheets?

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.

How do I use an array formula in 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).

What function should you use to join multiple strings in Google Sheets?

Appends strings to one another.


1 Answers

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

like image 180
Luchostein Avatar answered Sep 22 '22 23:09

Luchostein