> For the complete documentation index, see [llms.txt](https://docs.nedyx.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/rowtorange.md).

# ROWTORANGE

Converts the cells of a row into a range.

#### 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://3862539772-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F4X6nN2wTlDsVpd8P1WDM%2Fuploads%2FzPRoklP8A2tX7gvNjxhO%2Fgrafik.png?alt=media&amp;token=adcfe4f6-86e7-4d2e-b8b6-47e191e8f19b" alt=""><figcaption></figcaption></figure>