Combine column- two lists, with unique identifier

I have two lists with, both with the same named/numbered columns. Each has a list of names in the first "name of" column, but different values in two of the other columns, though some names are shared between the two lists (CSV format). I want to combine the two lists, but combining the values of the other two columns, placing them in the correct row.

Example:

(List one)
Column A Column B Column C Column D
John Smith yes - -
Bob Smith - yes -
Joe Smith - yes -

(List one)
Column A Column B Column C Column D
John Smith - yes -
Jill - - yes
Bob Smith yes - -


Combined...what I want
Column A Column B Column C Column D
John Smith yes yes -
Jill - - yes
Bob Smith yes yes -



Does this make sense? I basically want to combine the files, and retain the column values, without duplicating the rows.

Thanks...Bryan

Try pasting all of the data into a single sheet. Then using a pivot table make the name your row label and then each of the three columns your values.

Then you can simply copy this and replace the values with Yes

Might be a better suggestion but this will work.