How to multiple rows of a column into single rows by combining the data in each row. Avoid trying to use Pivot and then combining columns. Instead use this simple technique that uses the Text.Combine Power Query function. The result is a single, delimited entry with each row containing the combined values for all of the rows.
![](https://s2.save4k.ru/pic/Ien8MAvPtVE/maxresdefault.jpg)