Hi, I am using PowerBI desktop with a live connection and looking to combine two ordered lists (List 1 and List 2) so that common values are aligned as shown in the combined list below. How do I do this?
Sorry that not clear. I am after a new sort order so that when each list is sorted the same values have the same sort order. For example value B is order 1 in List 1 and order 3 in list B. I want to sort so B etc has the same position in both lists while retaing the existing order of items. The letters represent the sequence of stops on two different bus routes.