Sort each column individually (over 100 columns)

[efforting]

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. 

[efforting]

Thank you. Worked for me too.

[Anonymous · Accepted solution]

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