List.Combine Function in Power Query

The List.Combine function takes a list of lists, and merges them into a single new list. In this function at the time of merging the lists the duplicates are retained. It is different from the List.Union function where at the time of merging the list the duplicates are removed.

Syntax

List.Combine(lists as list) as list

Example:

Power Query M

let
  list1  = {"Ashish", "Esha", "Katrina"},
  list2  = {"Samyukta", "Esha", "Jennifer"},
  list3  = {"Alia", "Warina", "Katrina"}, 
  return = List.Combine({list1, list2, list3})
in
  return

The output of the above code is shown below:

Previous Next