Concatenate, Merge or Combine multiple rows into one value - Power Query for Power BI

A relatively new feature of Power Query that helps you concatenate, merge or combine multiple rows of data into a single value with just a few clicks. The video showcases some advanced scenarios where you might want to shorten the end value and only take in consideration a few elements to concatenate.

Download the Origin file here:

[lenac]

This is exactly what I'm looking for to compile a list of survey questionnaires! We have seen alot about merging columns but less about merging rows. After 2 years this is still so relevant. Danke!

[davidpwongphoto]

I started using Power Query on and off. OMG this is so good. Exactly what I needed.

[prabhupandiarajan]

Fantastic. Spent almost a day to combine the multiple rows in one cell.

[industrialrevolution]

You are a genius, I've spent 10 hours trying to read forums to achieve the same and i stumbled upon your video. I got what i was looking for, thank you very much. Subscribed as well.

[lukasseifriedsberger]

Thanks bud! Really didn't know that amazing concatenation feature of grouped rows existed, and it was EXACTLY what i needed!

[davidubl]

Thanks for introducing me to Aggregate All Rows and Table.Column. Incredibly powerful! Kick started my thinking to solve a problem I've been struggling with for a long time.

[hapcoding]

Thank you. It really solve my problem. What I want is make a unique row before pivoting my column. Your video solves my problem. Thank you so much.

[AP-ebhd]

Exactly what I was looking for. Thanks for the upload.

[natusikyagusik]

I am so thankful that I found your video. I am new to the Power BI, and this method was a lifesaver. Thank you for sharing!

[decentmendreams]

Greetings, I am always amazed by your strong command of PowerBI/Power Query. Your analytical skills are just incredible. I follow all your videos which I find them very helpful. Thank you so much.

[vimalmanavalan]

one of the coolest video i ever seen in powerbi. thanks alot for the explanations. it really helped me a lot.. love from India

[sahilsharma-cxbp]

Thank you so much, it solved one of my biggest issue

[REgamesplayer]

To think that I tried to do this task for a week. I could not find anyone talking about in forums. I tried programming, but PBI seems to be particularly awful with for functionality if it even has it. You however had brought exactly what I needed to finish the most annoying second half of my project. I had a very nasty DWH table with relevant data not only in different rows, but columns also. It took an ungodly amount of time and actions just to clean it up properly.

[chrisnosal]

this was a very useful video. I was googling what I was trying to do and got lucky as this was the first video that came up and was exactly what I needed. Thanks!

[osmanyldiz]

I was about to go ballistics before I find this, you solved my problem, thanks mate

[phyberoptx]

This helped me avoid some snowflaking in my data model. Thank you very much!

[sirasnet]

You are the best I have seen in power query. Good

[ulisesgabrielignotflores]

This made my life easier, thank you!!!

[naomieketa]

Thank you! If you only knew what this unlocked and how much of it helped...

[ensysconsultores]

Just what I needed. I was playing around with get data from PDF and some lines of text were split in several lines. With this trick I can put them back in the same row. Thanks