Forum Discussion
Reorder Cell Data Using Power Query
I'm trying to take a list of items, reorder the data in a single cell, and then alphabetize the column. Alphabetizing the column is easy but reordering the data in a cell is tripping me up. I know I ...
I agree, I couldn't make sense of the sort order. I can get there with a LAMBDA function, but the weird sort order throws me. I can't understand the logic of the sort order for expected outcomes
Mark_J_Walker , I also don't know which exactly logic shall be. My understandings:
- we sort words in each row of the original list in alphabetical order
- sort list by first word in each row, next by number of words in the rest of each row, next for each group with the same number of words in alphabetical order