split_column_to_rows
Split a text column on a delimiter so each part becomes its own row. Appends Table.SplitColumn and Table.ExpandListColumn to the table's M query.
Instructions
Power Query Split Column into Rows: split a text column on a delimiter so each part becomes its own row. Appends Table.SplitColumn (into a list) + Table.ExpandListColumn to the table's M query.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| column | Yes | the column to split into rows | |
| delimiter | Yes | the delimiter to split on, e.g. "," | |
| sessionId | Yes | ||
| partitionName | No | partition name (optional; defaults to the first partition) |