Grouping Data with Power Query

[@harishpaldhir9517]

DEAR SIR THANKS A BILLION TIMES AS I GOT SOLUTION FROM YOUR GUIDANCE IN CONCATENATING ROW DATA IN A SINGLE CELL VALUE I HAVE BEEN TRYING TO FIND THIS FOR LAST TWO YEARS THANKS AGAIN SIR

[@DougHExcel]

Thanks HARISH PAL DHIR, glad it helped!

[@harishpaldhir5915]

Thank you sir U have solved my biggest problem I have been lokking ways to concatinate rows for the last two years and u have guided me in this in the simplest and easyiest way Thanks again sir 😇😇😇😇😇

[@DougHExcel]

Thanks HARISH PAL DHIR, glad it helped!

[@lorihewig891]

Thanks for the great example and step-by-step approach. I appreciate your highlighting the differences between power query and pivot tables.

[@DougHExcel]

Hi Lori Hewig...you're welcome, glad you liked!

[@mgupta10]

Very impressive!! A big thumbs up for the presentation skills and showing the power of Power Query.

[@DougHExcel]

Thank you very much!

[@deninsrmic4165]

Great tutorial Doug!!!

[@DougHExcel]

Thanks Denin Srmic!

[@fennecfennec5234]

Thank you so much . The demonstration is very helpful

[@DougHExcel]

Glad it was helpful!

[@rdg515]

13:40 adds a column that concatenates uniques values for a column for each aggregated row

[@DougHExcel]

Hi rdg515, thanks for the comment

[@BezUmiaru]

Amazing! Nothing else to add!

[@DougHExcel]

Thanks!

[@cereskinomoto2004]

Very informative.. Well explained.. love it 🤩

[@DougHExcel]

Thanks!!

[@lukaseller8776]

You are the Best!

[@DougHExcel]

Thanks for the kind words!

[@maggiebarr5599]

Thank you so much for this!!! You are an angel!!!

[@DougHExcel]

Hi Maggie Barr, glad you liked it, thanks for commenting!

[@vijaysahal4556]

Amazing sir 👍🏻👍🏻👍🏻👍🏻💯💯💯💯🔥

[@DougHExcel]

Thanks for the comment!!

[@SimX9000]

Thank you, super helpful!

[@DougHExcel]

Glad it was helpful!

[@Muuip]

Great presentation! Very useful, thank you.

[@DougHExcel]

Hi Muuip...you're welcome, glad you liked!

[@NaraMeerammaTrust]

where do i get the Power Query M Code training yu mentioned in this video? Can you please let me know the website? I wanted to learn ASAP. Thank you in advance.

[@DougHExcel]

Which timeslot? Probably stuff from Ken Puls...?

[@kennethstephani692]

Great video!

[@DougHExcel]

Glad you enjoyed it

[@DataAnalytics2486]

Hi Doug, Thank you for this great video! Is there a way to apply these steps across multiple tables with the same column names (tables need to stay separate)?

[@DougHExcel]

Yes you can if the columns headers are exactly the same, just do the steps with one table, make a copy of that query and change the source for the next table

[@dagordon1]

Thank you! What a simple way to concatenate several text items into the same cell automatically.

[@DougHExcel]

You're very welcome!

[@hamzamottali3567]

thank you, it worked with me, but i have such an error : DataFormat.Error: There were more columns in the result than expected, I had it juse in some rows could you please give a help

[@guptamols]

Thanks for the informative video, What if values are required in different columns rather than comma separated ?

[@DougHExcel]

Try to the pivot feature in power query kzbin.info/www/bejne/ZmG9nXqNgaaqm80

[@fennecfennec5234]

Hi Doug . Could you please share how to to add sorting to final result for example ( a,b ) , (b,a) to show only (a,b) . I tried to use table.sort and List.sort but IT doesn't work. Thank you in Advance for your help.

[@fennecfennec5234]

I did it with if function but for each new combination I have to add an if clause

[@saikrishna9069]

Thank you so much but when we have numbers where should we Number.Totext in M code

[@DougHExcel]

Something like this? kzbin.info/www/bejne/noqciIyIZZuirsU

[@TheLaopi]

Hi very helpfull, can you share file to mâle again the exercice thanks

[@DougHExcel]

Hi Pierre GARTISER, thanks for the comment! ... sorry don't have files to download :-(

[@saidzazai3621]

Thanks for this. I noticed that after creating this concatenated list my counts were not correct and I fixed it by swapping the position of your Table.Transpose with Table.Distinct. Basically, I am taking distinct after transposition. Thought i'll share this in case someone is having the same problem.

[@DougHExcel]

Hi Said Zazai, thanks for adding to the thread!

[@michaeljones2843]

Awesome example Thanks!

[@DougHExcel]

Thanks for the comment!

[@christianstork1049]

Thanks for showing that this is possible. The formula can be simplfied though, I think. Something along the lines of: =Text.Combine(List.Distinct([Region]), ",")

[@DougHExcel]

Hi Christian Stork, thanks for the comment and adding the tip to the thread!

[@MrKamranhaider0]

Dear , If we want combine two or more column like you do only region.

[@DougHExcel]

Hi Kamran Haider, thanks for the comment! There is a combine columns feature (with delimiter) you can use in the PQ editor

[@cereskinomoto2004]

Hi Sir, i work in a hospital ang i would like to request a tutorial on how to calculate patient readmission, and how do i flag pts that had a readmission

[@DougHExcel]

Maybe try >> Highlight Cells that Match with Conditional Formatting kzbin.info/www/bejne/nZDTqWWafLhoi6c

[@dionis87]

many thanks!

[@DougHExcel]

You're Welcome!

[@aekmit]

yes, this can help :) I'm feeling lucky to subscribed your channel Thank you so much!! Hi Doug H may i have one question, can we apply 'slicer' to control this pq?

[@DougHExcel]

slicer will not control the query per se (although i think you can apply a slicer of a table that is an input to another query). The output of the pq in the table...you can apply a slicer to that table.

[@aekmit]

Thank you so much for your advise, ok i will try that. :)

[@perfectionist810]

Could you post the M code you pasted?

[@DougHExcel]

Hi perfectionist810, sorry don't have files to download :-(

[@Tat-cx1lr]

Dommage vous ne faites plus de vidéos!!!!

[@DougHExcel]

J'ai beaucoup plus de vidéos! Abonnez-vous à la chaîne à afficher. Merci! kzbin.info