google-spreadsheet Using arrays in Google Sheets Returning a range as an array
Example
| Row | A | B |
|---|---|---|
| 1 | Fruit | Apple |
| 2 | Weekday | Monday |
| 3 | Animal | Dog |
Formula on C1
={A1:A3}
Result
| Row | C |
|---|---|
| 1 | Fruit |
| 2 | Weekday |
| 3 | Dog |
Alternative formula
=ARRAYFORMULA(A1:A3)
| Row | A | B |
|---|---|---|
| 1 | Fruit | Apple |
| 2 | Weekday | Monday |
| 3 | Animal | Dog |
Formula on C1
={A1:A3}
Result
| Row | C |
|---|---|
| 1 | Fruit |
| 2 | Weekday |
| 3 | Dog |
Alternative formula
=ARRAYFORMULA(A1:A3)
