Dear all,
I would like to merge two lists in Excel 2007 while keeping some information associated with one of them.
List 1:
and List 2:a b e
List 1 does not contain all headers from List 2, only a selection.a data1 data2 data x b data1 data2 data x c data1 data2 data x d data1 data2 data x e data1 data2 data x
List 2 contains more data associated with headers that I would like to keep.
Using the the example above, I would then like to obtain:
I've tried to fiddle a bit with the functions in the "Data" tab, but I can't really get anything conclusive.a data1 data2 data x b data1 data2 data x e data1 data2 data x
Thank you very much for your help and your time!
GM.
Bookmarks