Splitter.SplitByNothing
Makes a function that does not split: it puts any value whole into a list of one.
Group: Splitters, combiners, replacers and comparers. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Splitter.SplitByNothing() as functionIt takes no parameters.
Returns
function. A splitter that gives a list holding the value it is given.
Remarks
Table.FromListuses it to turn a list into a one-column table, each item a row as it is: dates stay dates, records stay records.
Examples
A list of products as a table
Table.FromList({"Chair", "Desk"}, Splitter.SplitByNothing(), {"Product"})| Product |
|---|
| Chair |
| Desk |
Text with commas is left whole
Splitter.SplitByNothing()("Oslo, Bergen"){"Oslo, Bergen"}Not only text
Splitter.SplitByNothing()(#date(2026, 3, 1)){#date(2026, 3, 1)}