google-spreadsheet Using arrays in Google Sheets Array of literals
Example
Formula in A1
={"Item name","Quantity";"Apples",2;"Blueberries",5}
Important: In certain countries the comma is used as a decimal separator (e.g: €1,00). If that's your case, you would need to use backslashes ( \ ) instead: (Docs)
={"Item name"\"Quantity";"Apples"\2;"Blueberries"\5}
Result
| Row | A | B |
|---|---|---|
| 1 | Item name | Quantity |
| 2 | Apples | 2 |
| 3 | Blueberries | 5 |
