Forum Discussion
Sort each column individually (over 100 columns)
Hello,
In power query, Is it possible with over 100 rows to sort each column so that all columns are in ascending order?
For example, once I load my data it looks like this:
| Column 1 | Column 2 | Column 3 | Column 4 | Column 5 |
| 1 | 2 | 3 | 4 | 5 |
| 2 | 1 | 1 | 1 | 1 |
| 3 | 3 | 2 | 3 | 4 |
| 4 | 4 | 4 | 5 | 2 |
| 5 | 5 | 5 | 2 | 3 |
| Column 1 | Column 2 | Column 3 | Column 4 | Column 5 |
| 1 | 1 | 1 | 1 | 1 |
| 2 | 2 | 2 | 2 | 2 |
| 3 | 3 | 3 | 3 | 3 |
| 4 | 4 | 4 | 4 | 4 |
| 5 | 5 | 5 | 5 | 5 |
Thank you.
Hello, it worked for me, don´t know about how good or bad the performance might be, hope it helps.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTICYmMgNgFiU6VYnWiwiCEKBokaQ9Uh1INETaA6IbpBsiBRUyjPFK4+NhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Column 1" = _t, #"Column 2" = _t, #"Column 3" = _t, #"Column 4" = _t, #"Column 5" = _t]),
Custom1 = Table.ToColumns (Source),
Custom2 = List.Transform(Custom1, List.Sort),
Custom3 = Table.FromColumns(Custom2)
in
Custom3
2 Replies
Hello, it worked for me, don´t know about how good or bad the performance might be, hope it helps.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTICYmMgNgFiU6VYnWiwiCEKBokaQ9Uh1INETaA6IbpBsiBRUyjPFK4+NhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Column 1" = _t, #"Column 2" = _t, #"Column 3" = _t, #"Column 4" = _t, #"Column 5" = _t]),
Custom1 = Table.ToColumns (Source),
Custom2 = List.Transform(Custom1, List.Sort),
Custom3 = Table.FromColumns(Custom2)
in
Custom3Thank you. Worked for me too.
