Comment on page
Table.ExpandListColumn
Given a column of lists in a table, create a copy of a row for each value in its list.
function (table
as table,column
as text) as table
Given a
table
, where a column
is a list of values, splits the list into a row for each value. Values in the other columns are duplicated in each new row created.Table.Transformation
Split the list column [Name] in the table.
Table.ExpandListColumn(Table.FromRecords({[Name= {"Bob", "Jim", "Paul"}, Discount = .15]}), "Name")
Table.FromRecords({[Name="Bob", Discount=0.15],[Name="Jim", Discount=0.15],[Name="Paul", Discount=0.15]})
Last modified 5yr ago