# ROWS

#### Syntax

**ROWS**(*range*; *rowIndex1*; row*Index2*; …; row*IndexN*)

* *range* - the range from which the rows should be extracted *- **Value type**: range*
* *rowIndex1-N* - the indicees of the rows which should be included in the return range - ***Value type**: number*

#### Remarks

* The order of the rows in the return range is the same as the order of the *rowIndex* parameters.
* If a row does not exist in *range*, a row with empty cells is included in the range.
* It is possible to use the same index multiple times, then the same row is included multiple times in the result range.

#### Examples

The left table is filled with the rows 1 and 3 of table1:

<div align="left"><figure><img src="https://3148043601-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL43fiRbeRtPnTjMpbGNO%2Fuploads%2Fgit-blob-3f05e18b483fbd0ddd24d1d3196e4d35cbc612df%2Fgrafik%20(540).png?alt=media" alt=""><figcaption></figcaption></figure></div>

The left table is filled with several rows of table2 in a custom order. Including an empty row, by using 0 as index:

<div align="left"><figure><img src="https://3148043601-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL43fiRbeRtPnTjMpbGNO%2Fuploads%2Fgit-blob-8fefd1616e2da10cf70b0ed720366a3210707ea4%2Fgrafik%20(541).png?alt=media" alt=""><figcaption></figcaption></figure></div>