Table.ExpandListColumn

About

Given a column of lists in a table, create a copy of a row for each value in its list.

Syntax

Table.ExpandListColumn(table as table, column as text) as table  

Arguments

Argument Description
table The Table to modify.
column The column to expand.

Example

Table.ExpandListColumn(  

    Table.FromRecords(  

    {  

    [Name= {"Bob", "Jim", "Paul"}, Discount = .15]  

}), "Name")  
Name Discount
Bob 0.15
Jim 0.15
Paul 0.15