Power Query - Combine rows into a single cell | Change data to readable format | Excel Off The Grid 

OMG THIS IS EXACTLY WHAT I NEED!! you are very straight to the point without any unnecessary remarks and I literally get what I want after following your instructions first time! thanks for making the complex simple for me :)

I've searched and found other ways of doing this, but your approach and delivery was super-simple. Thanks so much for this very useful video.

May almighty Allah Bless You. I have been trying to solve this for three consecutive days now. Thank you so much.

Thank you so much 🙏 this is EXACTLY what i needed in my current job i’m so happy i learned something valuable …i couldnt find the solution anywhere on the internet i just found your video by coincidence i subscribe !

I've been searching to do this for weeks. Thanks a lot!!!!!!!!!!!!!!!!!!!!!

You are my savior. Your method is simple but very powerful.

What you just illustrated is power query pivot table basically. So cool.

Saved my precious time..God bless you... You don't have an idea how much of a value this video is in my workplace.

Very nice! This is much better than grouping all rows then extracting the list. Thank you

You were such a savior, I was trying exactly same thing for last few days. Thanks a lot!!!

A concise explanation of exactly what I needed - very helpful! 🙂

Amazing good. It took me hours untill I spotted your youtube post. Thank you for posting. Absolutely SPOT ON ! In Dutch: Combineer regels in een enkele cel -> gebruik "Groeperen op"

Superbly clear explanation. Just what I was looking for.

Thank you for this video! it was a tremendous help and exactly what I needed. Would be awesome if you will make more videos using Power Query.

Awesome, short and crisp! exactly what I needed

Holy shit dude this is freaking awesome. You are a lifesaver. You've got yourself a subscriber over here. THANKS SO MUCH. Short and sweet directly to the point. LOVE IT!!

Have been trying to achieve this for the past hour and couldn't get it to work until I came across this video. Works perfectly! Thanks for sharing.

I agree with Alvin! This saved me countless hours. Very good video.

Hi Mark. Awesome example! Thanks for sharing how to do this.. will come in handy in the future :)) Thumbs up!!

Very helpful for Power BI manipulations as well!

Was trying to do this in a Power BI transform... this is exactly what I needed. Thank you very much!!

I want to give you money! You are a life saver!

Well done, Mark!

Thanks so much, this is perfect solution for the challenge I was facing! Such a plot twist when he was like "we're going to select "sum", knowing full well it will result in an error"

This is brilliant! Thank you so much for posting this

Exactly what I needed! Thank you very much!

Excellent, thanks from Brazil!!

Super! What was I'm searching for. Thanks a lot.

this is what i've been looking for, thankyou very much sir

That's the easiest solution, thank you!

Holy smoke.... I've been looking for this for hours due to issues I'm experiencing pulling data from an old MS Access Db within which some muppet has created LOOKUP fields in a table. Thanks so much!

Great video with an excellent sollution!! I love your technique for combining text using the group by feature. Thanks for sharing.

Worked perfectly. Thank you :3

Thank you very much!

Thank you. Brilliant real life application

Man you saved my day big time

Thanks so much, this really help me a lots. Best

Brilliant. Thank you!

Awesome excellent method and presentation thanks so much!!!!

Awesome, this was super helpful!

Dear collegue, this is not what is described in the video titel, instead of combine "rows", it should be named in combine "columns", by the way. Cause I was looking for something which combines 2 rows and I'am getting this :)

Brilliant! Thank you very much!😀

Fantastic - great solution

EXACTLY WHAT I NEED!! Thanks

Great... Effective thing learnt today on excel..

Wow.... It's magic & thanks for sharing. Eager for more 😇

Superb Sir 👍👍👍👍

私がやりたかったことはコレです！ 英語は分かりませんが、とても理解しました。ありがとうございます。

Thanks man!

Awesome video and explanation, the backward version of your first one! haha!

Awesome solution!

Thank you!!!

Hi Mark, thank you this is super. I have subscribed to your channel.

Wow thanks a lot!!! Very useful!!

Thank you.

The best thing I learned today

Thank you so much! :)

It was fantastic. Thank you

Nice one!

thanks for complete to learn because simple file is ready and RU-vid to god for practice thanks you very much

Thank you so much! 💜💜

Brillaint!

Nice, solved a problem for me :)

Wow, he got it....Amazing.

Excellent video and content

excellent 👍👍

Thank you! Very helpful!

Thank you so much

thank you very much👍🏻👍🏻

Realy fantastic

Nice Video 👍

Amazing! Thanks!

Thank you so much for your help

only 1k likes? this video is a GEM

Merci et bravo

Bravo et merci

Was looking for this.. Will try it soon

Great video dude..! 💐💐👏

simple and easy

Thanks, hat off! :)

1:15 Merge 2:00 Group By

Thanks for this. How to do the reverse?

Great

Fantastic, thank you

king

helpful tnx:)

Thank you 😇😇😇

Now how do you make the separator a "tab" so have two rows in one text box?

what cannot we use the text.combine in the first place ? 3:38

Thanks for the video, i'm trying to use this method with Power Bi, but, after this when I split the equipment column by the delimiter into their own columns and the data is not equal as in one user doesn't have the same amount of equipment as the other it's messing up the report with invalid data in some columns, any ideas? thanks

Thanks for the amazing tutorial. How we can do opposite what you did?

Thank you so much!!! Could you please do it using R o Python?

Hi Mark greetengs from Colombia... I have a question.. If I Want concat all values in a cell and after to creat a variable it's posible? For example I have a column named DATA 1 2 3 4 and I want to build a variable named Data_number with all number and to add simple quotes... I would need this result... Data_number ('1','2','3','4')

Thank you Mark. That's a great help! What would you do if you get more than 10K lines consolidated in your new sheet? How to show all lines or split into another sheet? Many thanks

I want combine only single cell which have different value, if cells have same value, it pass? the cell results do not show duplicate values

I downloaded yr example but my excel doesn't have the "from table range" option. :(

How do you do the exact same thing, but with numbers instead of text? I want to combine in one cell a series of number values for a person, separated by a comma and space.

I have an address book in an excel sheet that has got a little messed up and wondered if this could help? The table has 15 columns (first name, last name, full name, company etc). The full name column is unique to each person but unfortunately there are duplicate rows for this and even worse, some of those rows have differing data from each other. If there was some way to group all rows with the same "full name" into a single row, and then have each column in that row contain all the unique values seperated by a delimiter such as ";" that would make my job of untangling this unholy mess so much easier. Hope that makes sense? Any help massively welcomed!

Challenge for you.. Can you do per the below? Row 1 - low - 10 Row 2 - low - 15 Row 3 - low - 20 Need to display like this in a same cell. Row 1 - low - 10 15 20 And not as single line 10, 15, 20.

Can we make the combination go into separate column but same row? If "justin" bought an apple, a laptop and a mouse, I dont want all these to be in one column but to become three different column titled "item 1," "item 2", "item 3". Is that possible?