List.Combine
Several lists joined end to end into one.
Group: List. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
List.Combine(lists as list) as list| Parameter | Type | Description |
|---|---|---|
lists | list | A list of lists. |
Returns
list. All the items, list after list.
Remarks
- Duplicates stay.
List.Unionkeeps a shared value only as often as one of the lists holds it.
Examples
Two shops' product lists
List.Combine({{"Coffee", "Tea"}, {"Tea", "Milk"}}){"Coffee", "Tea", "Tea", "Milk"}