I
ILunacy
I hope someone can help me out with this. Say I have column A filled with
like 500 names, and column B filled with 300 of the same names. Is there a
way or a formula to match the names in column B to the corresponding names in
column A, move the name in B to be in the same row as the name in A, and to
insert blank cells into B where there are no names to match A?
Example:
A B
Abe Abe
Brad Brian
Brian Chris
Chris
changed to:
A B
Abe Abe
Brad
Brian Brian
Chris Chris
Thanks
like 500 names, and column B filled with 300 of the same names. Is there a
way or a formula to match the names in column B to the corresponding names in
column A, move the name in B to be in the same row as the name in A, and to
insert blank cells into B where there are no names to match A?
Example:
A B
Abe Abe
Brad Brian
Brian Chris
Chris
changed to:
A B
Abe Abe
Brad
Brian Brian
Chris Chris
Thanks