← Back to List functions

List.Combine

Accepts a collection of lists and consolidates them into one cohesive list.

Syntax

List.Combine(lists as list) as list

About

Accepts a collection of lists and consolidates them into one cohesive list.

Explanation

Example 1: Merging two simple lists {1, 2} and {3, 4} can be done using the following Power Query function: MList.Combine({{1, 2}, {3, 4}}). The output of this operation will be {1, 2, 3, 4}. Example 2: To combine the lists {1, 2} and {3, {4, 5}}, where one list contains a nested list, use the Power Query function MList.Combine({{1, 2}, {3, {4, 5}}}). The result of this operation will be {1, 2, 3, {4, 5}}.