Power Query
Search…
List.Combine

List.Combine

Returns a single list by combining multiple lists.
function (lists as list) as list

Description

Takes a list of lists, lists, and merges them into a single new list.

Category

List.Transformation functions

Examples

Combine the two simple lists {1, 2} and {3, 4}.
1
List.Combine({ {1, 2}, {3, 4} })
Copied!
{ 1, 2, 3, 4 }
Combine the two lists, {1, 2} and {3, {4, 5} }, one of which contains a nested list.
1
List.Combine({ {1, 2}, {3, {4, 5} }})
Copied!
{ 1, 2, 3, {4, 5} }
Last modified 3yr ago