Table of contents
TOC
Collapse the table of content
Expand the table of content

Table.ExpandListColumn

Owen Duncan|Last Updated: 4/19/2018

About

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

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

Arguments

ArgumentDescription
tableThe Table to modify.
columnThe column to expand.

Example

Table.ExpandListColumn(  

    Table.FromRecords(  

    {  

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

}), "Name")  
NameDiscount
Bob0.15
Jim0.15
Paul0.15
© 2018 Microsoft