This is an article about specific transformation of split column values.

In many cases, it involves splitting the value. If it is just a basic splitting of the value, it can be achieved by using Split function in Power query. However, in the following case, the user has different values in each cell with "|" as a separator and needs to remove the separator and sort the values in reverse order based on the date after the separator is removed.