How to merge two excel files based on common column ?

I have two excel sheets that I need to combine into one.

For example

File1:

ID Name

1 abc

2 xyz

3 mno

File2:

ID Job

1 teacher

2 singer

3 driver

Once I import these two excel files, I want to combine them into one, based on the common column "ID"

Output file:

ID Name Job

1 abc teacher

2 xyz singer

3 mno driver

Answer 1

[Ameer Hamza]

See innerjoin(): https://www.mathworks.com/help/matlab/ref/innerjoin.html or outerjoin(): https://www.mathworks.com/help/matlab/ref/outerjoin.html. Use whichever is suited for your purpose.

[Namrata Goswami]

Thank you. This helped!