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
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 😇😇😇😇😇
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]), ",")
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.
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
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
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)?
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
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.
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.
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?
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.
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
Thanks HARISH PAL DHIR, glad it helped!
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
😇😇😇😇😇
Thanks HARISH PAL DHIR, glad it helped!
You are the Best!
Thanks for the kind words!
Thanks for the great example and step-by-step approach. I appreciate your highlighting the differences between power query and pivot tables.
Hi Lori Hewig...you're welcome, glad you liked!
Thank you so much for this!!! You are an angel!!!
Hi Maggie Barr, glad you liked it, thanks for commenting!
Thank you so much . The demonstration is very helpful
Glad it was helpful!
Very impressive!! A big thumbs up for the presentation skills and showing the power of Power Query.
Thank you very much!
Thank you, super helpful!
Glad it was helpful!
Great tutorial Doug!!!
Thanks Denin Srmic!
Thank you! What a simple way to concatenate several text items into the same cell automatically.
You're very welcome!
Great presentation!
Very useful, thank you.
Hi Muuip...you're welcome, glad you liked!
Amazing! Nothing else to add!
Thanks!
Amazing sir 👍🏻👍🏻👍🏻👍🏻💯💯💯💯🔥
Thanks for the comment!!
Very informative.. Well explained.. love it 🤩
Thanks!!
13:40 adds a column that concatenates uniques values for a column for each aggregated row
Hi rdg515, thanks for the comment
Awesome example
Thanks!
Thanks for the comment!
Great video!
Glad you enjoyed it
many thanks!
You're Welcome!
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]), ",")
Hi Christian Stork, thanks for the comment and adding the tip to the thread!
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.
Hi Said Zazai, thanks for adding to the thread!
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
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
Maybe try >> Highlight Cells that Match with Conditional Formatting
ua-cam.com/video/g_px2dGS5UE/v-deo.html
Thanks for the informative video,
What if values are required in different columns rather than comma separated ?
Try to the pivot feature in power query ua-cam.com/video/00ZlGWLAwek/v-deo.html
Hi very helpfull, can you share file to mâle again the exercice thanks
Hi Pierre GARTISER, thanks for the comment! ... sorry don't have files to download :-(
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)?
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
Thank you so much but when we have numbers where should we Number.Totext in M code
Something like this? ua-cam.com/video/hY9WYR06oxc/v-deo.html
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.
Which timeslot? Probably stuff from Ken Puls...?
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.
I did it with if function but for each new combination I have to add an if clause
Dear ,
If we want combine two or more column like you do only region.
Hi Kamran Haider, thanks for the comment! There is a combine columns feature (with delimiter) you can use in the PQ editor
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?
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.
Thank you so much for your advise, ok i will try that.
:)
Dommage vous ne faites plus de vidéos!!!!
J'ai beaucoup plus de vidéos! Abonnez-vous à la chaîne à afficher. Merci!
ua-cam.com/users/dough517
Could you post the M code you pasted?
Hi perfectionist810, sorry don't have files to download :-(