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 :)
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 !
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"
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!!
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"
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!
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!
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 :)
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.
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
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
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.
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.
You can use "#(lf)" instead of ";" in the Text.Combine. However this does lead to an issue when loaded into Excel. To resolve this follow the instructions in this post: www.thebiccountant.com/2016/04/16/how-to-display-power-query-results-with-line-feed/
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?
In Power Query, you can either (a) Pivot the data in or (b) enter into a single cell, then Split using a delimiter. Both provide different layouts and may provide what you need :-)