Hi,
If I needed to get at the values in a list of lists, I've used either List.Combine or Union, but have just found
Table.ExpandColumnList, my question is are there any advanctages that anyone knows of for using one over the other?
Combine is a lot easier,
I've attached workbook showing both and how I've used them
Table.Group(#"Grouped Rows", {"Tunits"}, {{"Count", each _ },
{"Customers", each List.Combine( [Clist] ) }} )
= Table.Group(#"Grouped Rows", {"Tunits"}, {{"Count", each _ },
{"Expand", each List.Distinct(
Table.ExpandListColumn(_, "Clist") [Clist] ) }} )
Richard.
Bookmarks