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.
Read more...
Specific transformation of split column values.pbix