Table.FromList Function to Generate Multiple Columns from One List
- V E Meganathan
- 17 minutes ago
- 1 min read
In this post, I will explain the default behavior of the Table.FromList function in Power Query.
Assume our source data has several values within a single column, separated by commas.
The goal is to split these values into separate columns and generate a table.
Within the Table.FromList function,
the list is, by default, treated as a list of text values separated by commas.
This default behavior allows us to split the values without needing extra functions.
Click on the link below for more detailed explanation.
let
Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
Result = Table.FromList(Source[Data], null,{"Date","Product","Sales"})
in
Result
Comments