Power Query: Combine rows into a single cell with Text.Combine

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:
https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning
Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2