ROW

Purpose:

Extracts a row of data from a table.

Syntax:

ROW(a, rownum)

a	-	A series or table.
rownum	-	An integer. The row number to extract.

Returns:

A row series.

Example:

W1: {{1, 4, 6},

{2, 5, 7},

{3, 6, 8}}

W2: row(W1, 2)

returns {{2, 5, 7}}

Example:

W1: {{1, 4, 6},

{2, 5, 7},

{3, 6, 8}}

W2: W1[2, ..]

returns {{2, 5, 7}}

Example:

transpose(row(W1, 3))

converts the row into a column of data.

Remarks:

To perform series operations on a single row of data, first use the TRANSPOSE function to convert the row into a column, or series. To select more than one row of data, use the REGION function.

See .. (Range Specifier) for more example of the array syntax method for extracting one or more rows and/or columns.

ROW

Purpose:

Syntax:

Returns:

Example:

Example:

Example:

Remarks:

See Also: