google-spreadsheet Using arrays in Google Sheets

30% OFF - 9th Anniversary discount on Entity Framework Extensions until December 15 with code: ZZZANNIVERSARY9

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



Got any google-spreadsheet Question?