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

Аватар автора
Учимся создавать дашборды в Excel
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&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&like to merge each person&details so that each person and their respective details are on a single row with their details in a single cell/column. 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. #PowerQuery #Grouping For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course: My book: Guerrilla Data Analysis 2nd Edition

0/0


0/0

0/0

0/0