## 2D-array

The

**is a special type of array that represents a two-dimensional ordered sequence of scalar (i.e. non-array) data.**

*2D-array*See also the array for an example of a

**of integers.**

*2D-array*In Excel, it is represented by a range of cells with

**rows and**

*N₁***columns.**

*N₂*The

**can be thought as a 1D-array of which the elements are**

*2D-array*

*1D-arrays*More precisely, a

**range represents a**

*N₁ x N₂***that is regarded to contain**

*2D-array***elements, each of which is a 1D-array with**

*N₁***elements.**

*N₂*In other words, the convention of the data ordering in a

**is first by rows and then by columns.**

*2D-array*It is possible to specify a

**of which the top level 1D-array elements have unequal size.**

*2D-array*This is achieved by setting a few selected cells to contain the special text

**, which marks the end of the respective row, as explained at 1D-array**

*[end]*A

**can be also constructed by a single row or column.**

*2D-array*If a function expects as input a

**, then the orientation of the corresponding range is important.**

*2D-array*For example, a single row of two cells is not the same with a single column of two cells, even if the cells contain the same data.

The former represents essentially only one 1D-array containing two values, while the latter represents a collection of two 1D-arrays, each containing one value.