Combine lists

The contents of two lists can be combined to construct a new list using the list-add operator (+). The items in the resulting list will be in the order they occurred in the original lists. Duplicate entries will be preserved.

  • ({1, 2, 3} + LIST(2, 3, 4)) produces a list of Number values: 1, 2, 3, 2, 3, 4. See also LIST().
  • (Employees[Office Phone] + Employees[Home Phone]) produces a list of all employee office and home phone numbers.

The list resulting from list addition will adopt the data type of the left-side list. If the right-side list is of a different data type, this may change how the values taken from it are interpreted.

  • ({3} + {3.14}) produces a list of Number values from a list of one Number value (3) and a list of one Decimal value (3.14).
  • (LIST() + {3.14}) produces a list of one Text value from an empty list (Text by default) and a list of one Decimal value (3.14)

See also

Construct a list using the LIST() expression

Construct a list of values

Subtract values from a list

INTERSECT()

LIST()

UNIQUE()

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false