Group Rows and Combine Text Values in Power Query
In this Power Query tutorial, you'll learn how to group rows and combine text values into a single record using the Group By feature.
This technique is useful when multiple rows exist for the same ID and you want to combine values into a single column.
Example transformation:
Before
X-01 Level 1
X-01 Level 3
After
X-01 Level 1, Level 3
In this video you will learn:
How to group rows by ID
How to combine multiple text values
How to use Power Query aggregation
How to create cleaner summarized tables
This method is widely used in:
Data cleaning
Reporting
Data modeling in Power BI