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

Syntax

=MM_HUNION(RangeOutput, [RangeOutput2], [RangeOuput3], [...])

• 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.

• ... (optional)
  Other ranges you want to bind. You can put a maximum of ten output ranges.

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, ..., etc. 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_VUNION to bind ranges vertically.

Example

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

Formula: =MM_HUNION(A3:A5,D3:D5,B3:B5) in the first cell below the header Col2 in the table #HUNION.
Returns the below table (headers were input manually):