# COMBINE

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

**COMBINE**(*range1*; *range2*; …; *rangeN*; *orientation*)

* *range1-N* - ranges of values - ***Value type**: range*
* *orientation* - the orientation of the combination - ***Value type**: constant (optional, <mark style="color:red;">horizontal</mark> as default).*\
  Possible values are:
  * *<mark style="color:red;">horizontal</mark>* - the ranges are combined horizontally
  * *<mark style="color:red;">vertical</mark>* - the ranges are combined vertically

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

* If *orientation* is *<mark style="color:red;">horizontal</mark>*, the total number of rows is defined by the range which contains the maximum number of rows for all ranges. For orientation *<mark style="color:red;">vertical</mark>* analogue.
* If a *range* is empty, it is not used for the combination (not even as an empty row or column).

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

In the two examples below table1 and table2 are combined horizontally (which is the default) and vertically.

![](https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-c7aedc74d696b56903128a36570d65d0c00dd260%2Fgrafik.png?alt=media)

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

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