How can I combine or merge 3 ordered lists?
by reveka on April 12, 2013Q: i have 3 lists
some items are on all lists, most are not.
i want to create a single list that will:
has all items on the list in the order that they are given in the seperate lists
for example.
list 1 is
M
B
A
D
list 2 is
C
F
M
Z
and list 3 is
F
D
Z
N
the final list should have these items sorted where they go based on their positions in the previous lists
so
C
F
M
B
A
D
Z
N
i’m using excel and its hard trying to copy these one at a time when the lists are bigger than the example.
if theres a website that i can input the data from the lists in and get the final product i would appreciate it.
