Expanding ListColumns within Nested Tables

Hi,

So you probably want something like this:

let
    Source =  
        Table.FromRecords(
            {
                [Name = "Bob",  Color = "Blue"],
                [Name = "Jim",  Color = "Yellow"],
                [Name = "Paul", Color = "Green"]
            }
        ),
#"AddTab;e"=
    Table.AddColumn (Source, "TypeID", each 
        Table.FromRecords(
            {
                [Type= "Small",     ID = {1,2,3}],
                [Type = "Medium",   ID = {2,4,6}],
                [Type = "Large",    ID = {1,3,6}]
            }
        )
    ),
    TransformColumn = Table.TransformColumns(#"AddTab;e",{"TypeID", each Table.ExpandListColumn(_, "ID")})
in
    TransformColumn

Hope it helps,

Artur