ROWS
Returns specific rows of a range.
Syntax
ROWS(range; rowIndex1; rowIndex2; …; rowIndexN)
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:
The left table is filled with several rows of table2 in a custom order. Including an empty row, by using 0 as index: