Split One Row into Many by Delimiter in Power Query M

Splits a delimited text value in one column into multiple rows, duplicating the rest of the row's values.

Table TransformationsIntermediatesplit rowsdelimiterreshape

Power Query M code

let
    Source = YourTable,
    SplitColumn = Table.TransformColumns(Source, {{"ColumnName", each Text.Split(_, ","), type list}}),
    ExpandedRows = Table.ExpandListColumn(SplitColumn, "ColumnName")
in
    ExpandedRows

Notes

Change "," to whatever delimiter separates the values packed into ColumnName.

Requirements

A table with a column containing delimiter-separated values that should become one row each.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Split One Row into Many by Delimiter.