Hi
I have this Excel problem which I'm struggling to solve.
Input lists = {1,2,3,4,5,6,7,9}, {3,4,5,x,a,8,z}, {c,b,5,6,8}
Output list = {1,2,3,4,c,b,5,6,7,x,a,8,z,9}
Input lists are a arranged by decreasing number of items and the first list has to be used as the starting list in which items from other lists will be inserted. Items preceding a matching value in second list, will be inserted above that item in the first list, and so on.
In my actual project all items in all input lists are numbers, not in any particular order and within each input list there are no duplicates.
How to do this in either Power Query or using Excel's dynamic array functions, whichever is scalable and efficient. I have over 200 cases each with 2 to 5 input lists.
Thanks in advance.
I have this Excel problem which I'm struggling to solve.
Input lists = {1,2,3,4,5,6,7,9}, {3,4,5,x,a,8,z}, {c,b,5,6,8}
Output list = {1,2,3,4,c,b,5,6,7,x,a,8,z,9}
Input lists are a arranged by decreasing number of items and the first list has to be used as the starting list in which items from other lists will be inserted. Items preceding a matching value in second list, will be inserted above that item in the first list, and so on.
In my actual project all items in all input lists are numbers, not in any particular order and within each input list there are no duplicates.
How to do this in either Power Query or using Excel's dynamic array functions, whichever is scalable and efficient. I have over 200 cases each with 2 to 5 input lists.
Thanks in advance.
