Custom order sorting in Excel

Help
1

Hello all,
I have a datatable lets say
|A|B|C|
|1|2|Two|
|3|5|Three|
|2|3|One|
And I would like to sort it by A (ASC) then B (ASC) and C by custom order (Two,One,Three) simultaneously so it would look like this.
|A|B|C|

|1|2|Two|
|2|3|One|
|3|5|Three|
I have tried via assign activity I found on this forum, but I dont know how to add the last part. So far I have this
(From x In datatable.AsEnumerable() Order By
convert.Tostring(x(“A")),
convert.ToString(x(“B”))
Select x).CopyToDataTable
but still missing the C part on how to sort by specific word order.
Thank you

2

Hello,

I am also looking for the exact requirement that you asked above. Have you got the solution? If yes, it would be great if you share here.

Thanks!