# TRANSPOSE

#### Syntax <a href="#syntax.58" id="syntax.58"></a>

**TRANSPOSE**(*range*)

* *range* - the range which is to be transposed - ***Value type**: range*

#### Remarks <a href="#remarks.42" id="remarks.42"></a>

* The function exchanges row and column coordinates of cell data values. So a value which has been in row 3 and column 4 will be in row 4 and column 3 afterwards.

#### Example <a href="#example.5" id="example.5"></a>

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

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