Concatenate Text Values using Group by in Power Query (w/ Optional Delimiter)

Have you always wanted to summarize text values using group by in Power Query? I've got you covered. This video shows the exact steps to take to group text values in Power BI.

WRITTEN ARTICLE:

Master Functions and Syntax in M

ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.

SUPPORT MY CHANNEL

SUBSCRIBE TO MY CHANNEL

LET'S CONNECT:

Thank you for your support!

#PowerBI #GroupText #BIGorilla

[Theuncommon]

Thank you! This is exactly what I was looking for. Saved me hours of manual sorting.

[pgplanas]

You, sir, are a life-saver. Thank you so much.

[LegalBro]

I keep coming back to this! Thank you, again!

[joaoleal]

You are a living god, I had a 60, 000 rows columns and could not figure this out for the life of me. Thank you very much!, subscribing and liking it.

[MichaelM.-iqih]

Amazing. Your channel is basically a PBI professional accelerator program. Thanks for all the time you put in! 👏🏻👏🏻

[robingeorge]

Thank you so much. I cannot believe how many convoluted ways there are to achieve this exact result online. Yours is perfectly concise. :-)

[mbanerjee]

Thank you so much. This is such a time saver. I used this back in 2022 and completely forgot until now.

[Trionyxification]

I used to utilize a whole arsenal of tools and tons of processing as well as mental power to achieve this. Yes, there's always a better way.😊
Thanks for sharing the trick, Rick.

[bhuvaneshbabu]

Just awesome. Exactly what i was looking for. I thought it was not possible. Thank You Rick 🙏

[digitama]

thank you, I have been stuck at this part for hours and it could turn into days without your help

[fxobcoh]

Thanks a lot, This video solved my requirement.

[gezin_longuevilleosaer]

Hoi Rick, SUPER!!! Net wat ik zocht en nodig had om een collega te helpen.

[GeorgiParvanov]

Great tip! Thank you for sharing the experience! It helped me a lot! :) Best wishes to you!

[amid]

Thank you so much Rick! Your videos are really clear and helpfull! Following you from France :)

[grewalguri]

Thank you so much, video helped a lot!

[diegolozano]

Thank you collegue, your video was soooo usefull, i send you a big hug from Colombia, great job

[don_johnson_vice]

Thanks much for the help)
I've spent some time finding how to solve this problem! Hopefully, I found it here=)

[NihonDream]

Holy Fuck! Brilliant! Absolutely fantastic! I cannot stop laughing - such a simple solution. Jesus, Mary and Joseph! You've made my day!!!! Thank you so much. I am a new devoted subscriber!

[natymim]

Thank you so much, I spent hours trying to figure it out by myself

[puzzlekuchen]

Hi, first of all: Thank you!
Can you help me how to remove the duplicates in the combined Text?
Edit: For everyone with this Problem this worked for me
Text.Combine(List.Distinct([Seller], ", ")