A question came in from someone who wanted to know how to merge rows of data into a single cell.
Imagine you have a person's name in one column and then details about the person on multiple rows; and then another name and details about that person; and so on ...
Now you'd like to merge each person's details so that each person and their respective details are on a single row with their details in a single cell/column.
To do this, I show Power Query and the Text.Combine function.
This video also demonstrates my example of building a small model so that we can focus on the solution and not a massive amount of our real data.
#Text.Combine
#PowerQuery
#Grouping
For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning
Website: ozdusoleil.com
My book: Guerrilla Data Analysis 2nd Edition
amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My old blog: datascopic.net/blog-2-2
- Power Query: Combine rows into a single cell with Text.Combine ( Download)
- Power Query - Combine rows into a single cell | Change data to readable format | Excel Off The Grid ( Download)
- Combine Multiple Rows into One Cell, Separated by Comma, Using Excel's Power Query ( Download)
- Power Query: How to collapse Multiple Rows to a Single Row ( Download)
- PowerQuery From Multiple Row to Single Row using Text.Combine ( Download)
- Concatenating Rows into a Single Cell in Power Query | Power BI Tutorial | MiTutorials ( Download)
- Concatenate Text Values using Group by in Power Query (w/ Optional Delimiter) ( Download)
- Combining text from cells in the same column in Power Query without combining the whole rows T0031 ( Download)
- Combine Multiple Rows into One Cell, Separated by Comma, Using Excel's Power Query ( Download)
- Merge Duplicate Rows in Excel Combining Unique Values in One Cell ( Download)
- Combine Rows of a Column in Power Query ( Download)
- Combine 2 rows into 1 record in Power Query ( Download)
- How to combine multiple row values into a single cell in Power Query using Power BI ( Download)
- Use Power BI, Power Query to Combine ( Concatenate, Merge ) multiple rows into a single row value. ( Download)
- Excel: How to Combine Multiple Rows into One Row ( Download)
