Binds ranges horizontally. Creates a new range by putting together ranges side-by-side.

Syntax

=MM_VUNION(RangeOutput, [RangeOutput2], [RangeOutput3])

• RangeOutput
  First range you want to bind.

• RangeOutput2 (optional)
  Second range you want to bind. RangeOutput2 must have at least the same number of rows as RangeOutput. 

• RangeOutput3 (optional)
  Third range you want to bind. RangeOutput3 must have at least the same number of rows as RangeOutput and RangeOutput2.

Remarks

• This function is not meant to be used inside another function. It must be used alone in a cell.

• Warning: In Excel, once a cell has been updated using this function, you cannot cancel this action.

• Best practice is to input headers manually, in other words, RangeOutput, RangeOutput2, and RangeOutput3 must not include headers or it may display two rows of headers.

• If the range parameters have inconsistent sizes, the function will return the error value NaN.

• Notice that the function MM_GETRANGE will automatically appear in your table. This function is used as an intermediate step by some functions from the add-in. It has no other purpose.

• See MM_HUNION to bind ranges horizontally. 

Example

We want to create a new table using #Table 1 and #Table 2.

Formula: =MM_VUNION(A3:B5,D3:E5) in #VUNION (first non-header value)
Returns the below table (headers were input manually):