I need to consolidate data (non numerical data) together. In Sheet #1
(NAMES) I have three columns. The first is a unique key "PAXID" followed by
"Last Name" and "First Name". On Sheet #2 (ADDRESSES) I have the same
"PAXID" column followed by "Address Line 1", "Address Line 2", City",
"State", and "Postal Code"

I need to join all these fields into a single sheet that would have PAXID,
Last Name, First Name, AddressLine1, AddressLine2, City, State and Postal
Code. There is a good chance that we have a person's name, but not their
address, so a PAXID, Last Name and First Name exist, but there would be no
entry in the ADDRESS sheet.

Is there an "easy" way to consolidate this kind of data?

John Jost
St. Louis MO