List.Split Function in Power Query

The List.Split function splits the given list into a list of lists using the specified page size.

Syntax

List.Split(list as list, pageSize as number) as list

Example:

Power Query M

let
  source = {"India", "America", "Canada", "Japan", "Australia", "England", "China"}, 
  return = List.Split(source, 2)
in
  return

The output of the above code is shown below:

{{"India", "America"}, {"Canada", "Japan"}, {"Australia", "England"}, {"China"}}

Previous Next