Search for all values contained in both lists or tables

The function * Union * compares two lists or tables.
The result is an aggregation of all the values contained in the two lists or tables.

In the case of tables, the number of the column to be searched is also specified.

The option * asc * arranges the result as ascending, * dsc * as a descending list.

## Union (list1, list2)

Compares two lists or the first two columns of a table.

## Union (table1, table2, column)

Compares the specified columns of both tables.

## Union (table1, table2, column1, column2)

Compares column 1 of the first table to column 2 of the second table.

## Union (table1, table1, column1, column2, "asc")

Compare column 1 with column 2 of the same table and arrange the result as an ascending list.

Union([3,6,4,8,6], [2,7,6,5,3])= 3 6 4 8 2 7 5

For tables, to display the complete rows in the result, set the *rows* option.
The options are given as the last argument and enclosed in quotation marks.
If rows is set, a common column number must be specified that applies to both tables.

Union (Tabelle1, Tabelle1, Spalte, "rows")

The option *asc* sorts the result in ascending order.

Union (list1, list2, "asc")

The option *dsc* sorts the result in descending order.

Union (table1, table2, column, "dsc")