Combine Rows into One Cell (Comma-Separated List) in Power Query M

Notes

ValueColumn must already be text; wrap it in Text.From(_) inside Text.Combine if it's numeric.

Requirements

• A table with a column to group by and a text column to combine.

How to use this snippet

1. 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).
2. Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
3. Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

• Group By with Multiple AggregationsGroups rows and computes several aggregations (sum, average, count) on different columns in a single step.
• Add Index Column Within Each GroupAdds a sequential index that restarts at 1 for every group, instead of numbering the whole table.
• Rank Within GroupRanks rows within each group by a numeric column, highest value first.
• Pivot ColumnsTurns unique values from one column into separate columns, aggregating another column.
• Unpivot Month ColumnsUnpivots only the columns that look like month names, leaving key columns like ID or Region untouched.
• Pivot Without AggregationPivots a column into new columns while keeping the raw values, for cases where each group only has one row per pivoted category.

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Combine Rows into One Cell (Comma-Separated List).