# PIVOT

#### Syntax

**PIVOT**(*range; numRowElements*)

1. *range* - the range whose content should be converted in a pivot structure - ***Value type**: a range of any data*
2. *numRowElements* - specifies how many starting columns from *range* should be used for the rows of the result range - ***Value type**: integer (optional, default value: 1)*

#### Remark <a href="#remarks.30" id="remarks.30"></a>

* The function converts the single values from range into values in multiple columns in the result range. Each value is specified by its (single or multiple) row and column attributes.

#### Examples

**Example 1** - PIVOT with one column for rows and one column for columns.

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

**Example 2** - PIVOT function with two columns with row attributes.

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

**Example 3** - PIVOT function with two columns with column attributes.

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