How to merge 2 different Excel Sheets into one

Hi All,
I have some people data that need to manage using in MS Excel 2010. I've 2 separate excel worksheets that have almost common data for example

Sr Name Contact location
in the first file is |10|John| (347)xxx-xxxx | Lansing, Mi. |

in the Second file it is just just have at |20|John|

I want to merge both files and no one should be double in the file file 1 have full data and file have just names and file one has complete and file 2 has just name just there are few more people that are no listed in file 2 that need to add in file 1 . How I can do it please let me know

Originally Posted by popipipo

Put everything in 1 worksheet and use 'remove duplicates' in 'data' tab.

But It change the sequence of other columns. The other file has just single column when I do this the file 1 other columns disturbed.

Look. the file 1 has 1 million rows and 5 columns and file 2 has 1 million rows with one column. I need to change the first column of file 2 to file 1 and other columns should be change with respect to the sequence How I can do this

Originally Posted by popipipo

I meant a xls file and not a picture.
Without the xls file try this formula to see if data exist or not

Please Login or Register  to view this content.

File 1.xlsx

File 2.xlsx

Here are the both files there is just a minor difference. removed few emails from file 2 so how I can add file 2 in file 1 and emails, nname and details remain in the same row