# ROWTORANGE

#### Syntax

**RANGETOROW**(*row*; *numColumns*)

* *row* - the row which should be converted to a range - ***Value type**: row with cells of any value type*
* *numColumns* - the number of columns of the return range - ***Value type**: number*

#### Remarks

1. The function returns a range with
   1. *numColumns* as number of columns
   2. as many rows so that all cells of *row* are included
   3. the cells of *row* are added row-wise, from in the order from top left to bottom right
   4. the cells have the same value and value type as the according cells of *row*

#### Example

Here, the widget wine list row is converted to a range with an appropriate number of columns (5 in this case):

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-7e90eb0bd6429dd0003192361e4c590c3151c220%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>