Power Query
Search…
List.InsertRange

List.InsertRange

Inserts values into a list at the given index.
function (list as list, index as number, values as list) as list

Description

Returns a new list produced by inserting the values in values into list at index. The first position in the list is at index 0.

Category

List.Selection

Examples

Insert the list ({3, 4}) into the target list ({1, 2, 5}) at index 2.
1
List.InsertRange({1, 2, 5}, 2, {3, 4})
Copied!
{ 1, 2, 3, 4, 5 }
Insert a list with a nested list ({1, {1.1, 1.2} }) into a target list ({2, 3, 4}) at index 0.
1
List.InsertRange({2, 3, 4}, 0, {1, {1.1, 1.2} })
Copied!
{ 1, { 1.1, 1.2 }, 2, 3, 4 }
Last modified 3yr ago