How can I combine or merge 3 ordered lists?

by on April 12, 2013

Q: 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.