I have two spreadsheets I need to consolidate into one. The first looks
as follows:

w x y z
a ** ** **
b ** ** **
c ** ** **
d ** ** **


The second one:
j k l m
a ** ** **
b ** ** **
b ++ ++ ++
c ** ** **
c ++ ++ ++
c -- -- --
d ** ** **

all the stars, plusses and dashes stand for various different data. the
only thing the two spreadsheets have in common are column 1, and even in
column 1, spreadsheet two has multiple entries of different data with
the same row name.
I need the finished product to look as follows:
x y z k l m
a ** ** ** ** ** **
b ** ** ** ** ** **
b ** ** ** ++ ++ ++
c ** ** ** ** ** **
c ** ** ** ++ ++ ++
c ** ** ** -- -- --
d ** ** ** ** ** **

In words, add the last three columns from spreadsheet 2 onto the end of
spreadsheet one based on row name. When they are duplicate row names in
spreadsheet 2, duplicate xyz as many times as necessary to attach every
different instance of klm. I'm running excel 2002, and I also have
access to 2003. I would appreciate any help you could give me on this
matter. Thank you in advance.


--
Eagle784
------------------------------------------------------------------------
Eagle784's Profile: http://www.excelforum.com/member.php...o&userid=24261
View this thread: http://www.excelforum.com/showthread...hreadid=378688