Sort data in descending order in same cell

[Aden123]

I have some data that needed sorting in the same cell.

Current data

ABC019, ABC018, ABC010

Expected results

ABC010, ABC018, ABC019

[Anonymous · Accepted solution]

Hi,@Aden123 

I am glad to help you. 

According to your description, actually you want to sort data in ascending order in same cell? 

If I understand you correctly, then you can refer to my solution. 

1.Import the data into Power BI Desktop and click Transform data to open Power Query Edit. 

2.Choose Custom Column in Power Query Edit. 

3.Enter M language formulas to create new columns 

let
    Source = [Current data],
    SplitColumn = Text.Split(Source, ","),
    SortedList = List.Sort(SplitColumn, Order.Ascending),
    CombinedText = Text.Combine(SortedList, ",")
in
    CombinedText

Result : 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.