Merging Spreadsheets, Mostly Text Data, Single Column the same in the both "Name"

[samri1013]

Hi All,

I need help. I have 2 spreadsheets. In both spreadsheets COLUMN A is the same: Client Name.

The rest of the Columns in both spreadsheets, ie, Columns B to XY have information, text information, no numbers. (ie, I cannot used the consolidate data functions)

Some clients appears on both spreadsheets, others appear on one and not on the other.

I wanted to merge the spreadsheets, so that, I have a new single spreadsheet that has merged the information from columns b-xy from the 2 separate spreadsheets into one spreadsheet. The columns have different headings, the only things that is the same is the client names.

I want excel to match the client names from the two spreadsheets and merge the information for that clients from the two spreadsheets into one.


For ex:

Spreadsheet 1

A1: Name
b1: Hair colour
c1: height
d1: ***

Spreadsheet 2

a1: name
b1: address
b2 : country of origin
b3: destination country

I want the merged spreadsheet to look like this:

A1: Name
b1: Hair colour
c1: height
d1: ***
e1: name
f1: address
g1 : country of origin
h1: destination country

[dosydos]

do spreadsheets 1 and 2 both have the exact same people's names? or are there some names on spreadsheet 1 that are not on spreadsheet 2 or vice versa?

[newdoverman]

You have two columns for names. Are the names in both of those columns the same name or can they be different names?

[FlameRetired]

Do any of the clients appear multiple times in their respective sheets?

i.e. Will Client1 or other appear multiple times in sheet 1? Same for sheet 2? Are their records unique in sheet 2?

Edit Also is this a one-off project or will it be ongoing?