Forum Discussion
Solved
Help: Reordering the Values of each Row in Numerical Order
I have a company hierarchy levels that are in one column but they are not in numerical orders(image 1). My end goal is to have the levels in numerical order in one column(image 2). ...
Right click on the column --> Transform --> click on anything like lower case then edit the formula
= Table.TransformColumns(#"Changed Type",{{"Column1", each Text.Combine(List.Sort(Text.Split(_, ", ")), ", "), type text}})
