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

Table.ExpandListColumn

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

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