How to combine text and sort it by ascending order in power query

Formula: let
Source = Excel.Workbook(File.Contents("C:\Users\harishankar.jaiswal\Downloads\Sample Data.xlsx"), null, true),
Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"CategoryID", Int64.Type}, {"CategoryName", type text}, {"Description", type text}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"CategoryName"}, {{"Count", each Text.Combine(List.Sort([Description]),";"), type nullable text}})
in
#"Grouped Rows"


Thanks for watching. If you liked this video, make sure to subscribe for more!

Subscribe to watch more movie recaps videos like this!

Subscribe to our other social media accounts for daily updates, movie recommendations and more


Using of this video on other channels without our permission will be strictly prohibited.
▶Thumbs up if you like this video👍
▶Comment for any question and suggestion🙏🙌
▶Share this Video in Your Circle if You think helpful to friends.
▶Thanks for watching 💐
------------------------
What about your opinions? tell me in comment.
------------------------
Curated by Harry Viral
For More Such Videos Visit Our Channel.

Our some youtube channel videos Playlists:
Advanced Excel Videos:   • Плейлист  
Travel -    • Плейлист  
Motivational -   • Плейлист  
Tips and tricks-https://www.youtube.com/playlist?list...

Thanks For Watching!!!

About this Queries:
power query,power bi,combine text in power bi,power query sorting data in ascending order,power query sorting data in descending order,combine text power bi,power bi combine text,power query in excel,aggregate text in power bi,introduction to power query,combine text power query,power query combine text,power bi desktop,how to use textjoin in power query,how to concatenate in excel power query,excel how to use textjoin in power query