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

[@AlvinRyellPrada]

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 :)

[@ExcelOffTheGrid]

Great news. Glad I could help 😀

[@carolinelackey6963]

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.

[@ExcelOffTheGrid]

There are many ways to achieve the same result in Excel, so I'm glad you found this method useful. 👍

[@user-yq3ib7nr2e]

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

[@dtxgaming9061]

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

[@ExcelOffTheGrid]

Glad to help :-)

[@jhntravel]

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"

[@ExcelOffTheGrid]

Great news, glad I could help.

[@alib4859]

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 !

[@ExcelOffTheGrid]

Glad I could help. 😀

[@mjones53]

Thank you very much!

[@ExcelOffTheGrid]

No problem, glad I could help.

[@shankariyer62]

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

[@ExcelOffTheGrid]

Time saved … woop woop, target achieved ✅

[@kitty1977]

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

[@ExcelOffTheGrid]

Yes, you could think of it that way. Thanks :-)

[@thiagohobi]

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

[@ExcelOffTheGrid]

Glad I could help! 😁

[@brockstonebrink9312]

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

[@ExcelOffTheGrid]

Thanks, I’m glad you found it useful 👍

[@paulskelton8799]

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!

[@ExcelOffTheGrid]

You’re welcome, glad it helped. 😀

[@eshmeets]

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

[@ExcelOffTheGrid]

You’re welcome 😀

[@jamesharper2980]

Very helpful for Power BI manipulations as well!

[@ExcelOffTheGrid]

Absolutely! I'm glad you found it useful. 👍

[@roguenealer]

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

[@ExcelOffTheGrid]

And I'll happy take your money 😀 I'm glad it helped.

[@garyjones6397]

Superbly clear explanation. Just what I was looking for.

[@ExcelOffTheGrid]

Glad you liked it!

[@giaca69]

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

[@servespirit1991]

Worked perfectly. Thank you :3

[@nataliamiteva5460]

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.

[@ExcelOffTheGrid]

Thanks Natalia - I’m glad I could help.

[@StalinSergey]

Thank you!!!

[@ExcelOffTheGrid]

You're welcome!

[@ashishshiriskar123]

Superb Sir 👍👍👍👍

[@ExcelOffTheGrid]

Thanks 😊

[@traffichazard]

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

[@ExcelOffTheGrid]

Glad it was helpful!

[@JHallo182]

Thank you.

[@ExcelOffTheGrid]

You’re welcome.

[@thadpanik8933]

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

[@louism.4980]

Thank you so much! :)

[@ExcelOffTheGrid]

You're welcome!

[@qungu7251]

That's the easiest solution, thank you!

[@ExcelOffTheGrid]

"Easiest solution"... great news !

[@user-vz5dx2nz1v]

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

[@ExcelOffTheGrid]

Even though you don’t understand English, I’m glad you were able to follow the video 😀

[@sumardjo]

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

[@ExcelOffTheGrid]

Good stuff, Thank You.

[@jacknoble491]

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"

[@ExcelOffTheGrid]

Ha ha ha - I like to keep you all on you toes :-)

[@kendalllewis3992]

you all probably dont care but does someone know a way to log back into an Instagram account? I was dumb forgot my login password. I love any tricks you can give me!

[@kiangus3491]

@Kendall Lewis instablaster =)

[@whyskyd]

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

[@ExcelOffTheGrid]

That the great thing about Power Query and Power Pivot, while not exactly the same, 99.9% works on both Excel and Power BI.

[@whyskyd]

@@ExcelOffTheGrid You should start a Power BI (M) channel 😁

[@ExcelOffTheGrid]

@@whyskyd Maybe a Power BI channel is one for the future. I’m not too bad with M and DAX, but the visuals always confuse me. 😀

[@natiasurmava3438]

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.

[@ExcelOffTheGrid]

We’ve got lots of Power Query content on our channel, it’s out main focus. So make sure you check it out.

[@austinstubetv]

Nice one!

[@ExcelOffTheGrid]

Thank you! Cheers!

[@user-zq3tn9st5k]

Thank you. Brilliant real life application

[@ck2610]

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 :)

[@ExcelOffTheGrid]

Sorry, I disagree. This technique is combining rows. So I believe it is the right description. ‘Merge columns’ is a different feature which already exists.

[@muhammadrizky317]

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

[@ExcelOffTheGrid]

You are most welcome 😊

[@HatecraftPaladin]

Nice, solved a problem for me :)

[@ExcelOffTheGrid]

Yay!! Great stuff! Glad I could help.

[@Tat-cx1lr]

Merci et bravo

[@ExcelOffTheGrid]

Le suis content que vous l'ayez trouvé utile.

[@rpopecpa]

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

[@ExcelOffTheGrid]

Glad you found it useful 👍

[@vij2cob]

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

[@ExcelOffTheGrid]

Excellent. Glad I could help with that :-)

[@pharmacyholland3133]

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

[@ExcelOffTheGrid]

Great news - I’m glad you could put it to good use.

[@umesh2403]

Man you saved my day big time

[@ExcelOffTheGrid]

Thanks - glad I could help.

[@Tat-cx1lr]

Bravo et merci

[@ExcelOffTheGrid]

Thanks you 😀

[@elecirlisboa9155]

Excellent, thanks from Brazil!!

[@ExcelOffTheGrid]

You’re welcome 😀

[@dennismoreno2808]

Brilliant. Thank you!

[@ExcelOffTheGrid]

You’re welcome.

[@miller2640]

Well done, Mark!

[@TheBayBeeTJ01]

Exactly what I needed! Thank you very much!

[@ExcelOffTheGrid]

No problem. Thank you 👍

[@clarealexander7802]

Fantastic - great solution

[@ExcelOffTheGrid]

Thanks - it’s a pretty nice solution once it’s set up. 👍

[@smeems7320]

This is brilliant! Thank you so much for posting this

[@ExcelOffTheGrid]

You’re welcome. I’m glad you found it useful.

[@engahmedelbendary1566]

Realy fantastic

[@ExcelOffTheGrid]

Thank you! Cheers!

[@kirinde]

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!!

[@ExcelOffTheGrid]

Thanks - glad I could help. 😀

[@lenzypetty9371]

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

[@ExcelOffTheGrid]

Thanks - I’m glad you found it useful. 👍

[@thrishithravi1976]

Awesome, short and crisp! exactly what I needed

[@ExcelOffTheGrid]

Great news, glad I could help. 👍

[@prajwalshetty2047]

Nice Video 👍

[@ExcelOffTheGrid]

Thank you 👍

[@wayneedmondson1065]

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

[@ExcelOffTheGrid]

Thanks Wayne. 😀

[@peterpferdproductions1043]

Brilliant! Thank you very much!😀

[@ExcelOffTheGrid]

You’re welcome.

[@PeratchThitarom]

Thank you so much

[@pminamdar]

Thank you so much for your help

[@ExcelOffTheGrid]

No worries, I’m glad you can use it.

[@bartomiejzab6636]

Thanks man!

[@behzadghah]

It was fantastic. Thank you

[@ExcelOffTheGrid]

Thanks 😀

[@sankalulu]

EXACTLY WHAT I NEED!! Thanks

[@azizdabaz]

Amazing! Thanks!

[@ExcelOffTheGrid]

My please, I hope you can put it to good use.

[@ironsideo]

Wow, he got it....Amazing.

[@ExcelOffTheGrid]

Hopefully you’ve been able to put the techniques to good use.

[@michelledextre7976]

Thank you so much! 💜💜

[@ExcelOffTheGrid]

You’re welcome, glad I could help.

[@krishck8552]

The best thing I learned today

[@ExcelOffTheGrid]

Great news :-)

[@benhalicki9749]

Awesome solution!

[@ExcelOffTheGrid]

Thanks Ben 😀

[@aaronorelup4024]

Awesome, this was super helpful!

[@ExcelOffTheGrid]

Great news 😀

[@kebincui]

thank you very much👍🏻👍🏻

[@ExcelOffTheGrid]

No problem, glad I could help 😀

[@thiagomenezes6968]

excellent 👍👍

[@MrDhunpagla]

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

[@ExcelOffTheGrid]

It is all about knowing the right tricks, so maybe it is magic. 😀

[@CarlosJimenez-pb6dq]

Wow thanks a lot!!! Very useful!!

[@ExcelOffTheGrid]

Glad it was helpful!

[@johnosullivan827]

Excellent video and content

[@ExcelOffTheGrid]

Thanks John :-)

[@mrkzmusic]

Brillaint!

[@anchorpoints5026]

simple and easy

[@ExcelOffTheGrid]

Thank you 😊

[@seshakv]

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

[@ExcelOffTheGrid]

Thanks Venkata - I appreciate your support 😀

[@cbhiii]

Thank you! Very helpful!

[@ExcelOffTheGrid]

You're welcome! Glad I could help 😀

[@onfootonwheels8758]

Thanks for this. How to do the reverse?

[@ExcelOffTheGrid]

Check out this video: kzbin.info/www/bejne/m3TCeIaDd7-Khqc

[@spilledgraphics]

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

[@ExcelOffTheGrid]

Exactly. The solution is frustrating because it requires editing the M code to apply a function which should be part of the UI.

[@spilledgraphics]

@@ExcelOffTheGrid I agree, it should be 😁🙏

[@salvi2606]

Was looking for this.. Will try it soon

[@ExcelOffTheGrid]

Great news! Hopefully it worked for you 😀

[@salvi2606]

@@ExcelOffTheGrid no I don't have the latest version of excel.. 😢😢 I have 2007 😭😭😭..

[@salvi2606]

@@ExcelOffTheGrid OMG this worked.. Uve saved me so much time with this hack.. Can't thank you enough.. I suddenly feel like a genius

[@ExcelOffTheGrid]

@@salvi2606 Great news - enjoy the extra time you’ve saved. 😀

[@salvi2606]

@@ExcelOffTheGrid yes going to browse through ur other lessons to learn more..

[@terryamartey8457]

Great

[@ExcelOffTheGrid]

Thanks 😁

[@kathanagrawal9926]

helpful tnx:)

[@ExcelOffTheGrid]

You’re welcome.

[@Aussiepeoplestats]

only 1k likes? this video is a GEM

[@ExcelOffTheGrid]

Thankfully it’s not about likes, but helping people 😀

[@Rundtj45]

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

[@ExcelOffTheGrid]

You mean like this: kzbin.info/www/bejne/m3TCeIaDd7-Khqc

[@moezipp]

Thanks, hat off! :)

[@ExcelOffTheGrid]

You're welcome!

[@alexdre8888]

Fantastic, thank you

[@ExcelOffTheGrid]

You’re welcome 👍

[@JhustynEstevez]

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

[@ExcelOffTheGrid]

Sorry, Python and R aren’t my thing.

[@manekineko1199]

Thank you 😇😇😇

[@ExcelOffTheGrid]

You're welcome 😊

[@the_slidemaster]

Great video dude..! 💐💐👏

[@ExcelOffTheGrid]

Thanks. I'm glad it helped you :-)

[@babs_w2504]

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

[@ExcelOffTheGrid]

Hi - I'm not really sure I understand the question. Can you give a few more details about the scenario.

[@ericulry4743]

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

[@mjones53]

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

[@marcmaguire6446]

king

[@ExcelOffTheGrid]

😀

[@bhanvicom.2014]

Its really awesome, but could you do the same things with dates also? its not working

[@ExcelOffTheGrid]

I think you would need to convert the dates to text. It uses a Text.Combine() function, so by definition it would need to be text.

[@joshbrooks2492]

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.

[@joshbrooks2492]

Doing it this way, it sums the numbers (which I don't want) and making the changes in the code like you have done gives me an error.

[@ExcelOffTheGrid]

Change the data type to text before applying the Group By step.

[@j.rajesh487]

Hi, Thank you for the video. I am looking for something quite opp. I have comma-separated values in a column, need to map one to one with key ID. Please help out, its an urgent requirement. Thank you well in advance.

[@sergiomira741]

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')

[@syednayyar]

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

[@angel29031980]

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

[@ExcelOffTheGrid]

Using the scenario from the video… create a concatenated column with the First Name, Last Name, Equipment and Equipment Attribute columns. Remove duplicates to create a list of unique items. Then follow the rest of the video.

[@saranraj3012]

How to group it same example with numbers

[@ExcelOffTheGrid]

I'm guessing that converting the numbers to a text data type first should work.

[@chiny-h6445]

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

[@ExcelOffTheGrid]

What version of Excel do you have? Microsoft recently decided to rename the button From Sheet

[@planxlsm]

1:15 Merge 2:00 Group By