List.Split

Syntax

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

Description

Splits list into a list of lists where the first element of the output list is a list containing the first pageSize elements from the source list, the next element of the output list is a list containing the next pageSize elements from the source list, etc.

Reference Data

https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

Power Query M Functions / List Functions / List.Split