List.Zip
This function accepts a list of lists as input and outputs a new list of lists by merging items located at the same index position.
This function accepts a list of lists as input and outputs a new list of lists by merging items located at the same index position.
Example 1
Combines two lists {1, 2} and {3, 4} together using the Zip function.
Usage:
Power Query MList.Zip({{1, 2}, {3, 4}})
Output:
{ {1, 3},
{2, 4}}
Example 2
Combines two lists of different lengths {1, 2} and {3} together using the Zip function.
Usage:
Power Query MList.Zip({{1, 2}, {3}})
Output:
{ {1, 3},
{2, null}}