~ merge two spreadsheets with one sheet each into a new one based on m

[winbroken]

hey im trying to do hobby project and i have this really big problem: im trying to merge two spreadsheets with one sheet each into a new one. they should be merged based on matching ids in column A1:A1000, so the outcome would not have duplicated ids.

im assuming this is a common need but i couldn't find anything for excel 2013

please advise. link to a good video guide would be helpful and good.

 

[DavidE]

Excel 2010 has a "Remove Duplicates" in the Ribbon Data tab.
If Excel 2013 has this feature you should be able to copy the data from each sheet into a new single sheet.
Then use the "Remove Duplicates".

 

[winbroken]

*** THANKS SO MUCH!!

sorry i could i not explain this any better :/

i found what i needed -- Excel 2010 Tutorial Consolidating Data Microsoft Training Lesson 19.1 - YouTube

i needed to know what the word 'consolidate' in excel meant. this is by labels, so 'top row' and left column'

this is for making a map!

 

[winbroken]

sadly i need to request for aid again as i realised far too late that 'consolidate, from what i understand, only does numerical data...

advise please?

 

[winbroken]

it would be type B on Excel Data Matching Merger 2.1 but that script doesn't seem to work on excel 2013