Welcome to our Power Query blog. This week, I look at the M function List.Zip and its uses.
I have been looking at List functions in M language recently, and this one reminds me of my problems with null values in lists [please see Power Query: Sorry, Not on the List].
The description of the function in the Microsoft help pages is straightforward:
List.Zip[listsas list] as list
Takes a list of lists,and returns a list of lists combining items at the same position.
Since I have a simple example with two lists below, this will be my starting point. I also want to see if the function will cope with a null.