List.Repeat Function in Power Query

The List.Repeat function returns a list that results from repeating the specified number of times the given input list.

Syntax

List.Repeat(list as list, count as number) as list

Example: Repeat the list two times.

Power Query M

let
  Source = {"India", "America", "Canada", "Japan", "Australia", "England"}, 
  RepeatedList = List.Repeat(Source,2)
in
  RepeatedList

The output will be shown in the following image:

List.Repeat function in Power Query