List .Combine, versus Expand

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

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Richard.

Well that was my thinking, it's just that its used if you use the expand to new rows on the drop down, so thought it might have some
advantage, all I can think is that it says what it acutully does, and opposed to union or combine, which if you only have one list you want to get at
doesn't seem right.

RD