Power Query list of lists to Table

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.

Video liên quan

Chủ Đề