Forum Discussion
Solved
Reordering a list
I've got a data-set with a column containing a list like "A","B","C" and sometimes that column also has "B","C","A" or other sequence (here A, B and C represent string values). Naturally, there i...
Exactly!
And to your point, I could probably have used List.Intersect instead of List.Select, List.Contains.
I like that.
So you transform the string into a list, which becomes the value of a new column.
Then you create three columns and for each column you intersect the value of the list with the standard list for that column?
Exactly!
And to your point, I could probably have used List.Intersect instead of List.Select, List.Contains.