Use for questions about using arrays in Google Sheets
Use for questions about using arrays in Google Sheets like
={"Name","Favorite meal";"Ana","Spaghetti";"Ben","Hamburger"}
which is displayed as
| A | B
--+--------+----------------
1 | Name | Favorite meal
2 | Ana | Spaghetti
3 | Ben | Hamburger
NOTES:
- Some functions are able to use arrays as arguments but other require a reference.
- Spreadsheet using comma as a decimal separator should use
\
as column separator instead of a comma.
Related functions
Related tags
Reference