google-spreadsheetUsing arrays in Google Sheets


Syntax

  • ={item1,item2}
  • ={item2,item2;item3,item4}
  • ={{item1;item2},{item3,item4;item5,item6}}

Parameters

ParameterDetails
itemNIt could be a value, a cell reference, a range reference or a function

Remarks

Overview

An array of literals is written between curly brackets. Separators depends on the spreadsheet's regional configuration settings.

  • To separate columns, if the decimal separator is . use , but if the decimal separator is , then use \.
  • To separate rows use ;.

Official Documentation

Google Docs editors Help