Compare two excel sheets and get unique value from both into new

[Closed]
Report
-
Hi,
I have two excel sheets. Sheet 1 with 4 columns and sheet 2 with 2 columns. I need to compare column 1 of sheet1 with column 1 of sheet 2 if it matches i need to get all the corresponding values from sheet 1 and sheet 2 and write into new sheet3.

Example:

Sheet 1
Col1 Col2 Col3 Col4
ABC 123 na test1
DEF 456 N/A test 2
GHI 789 N/A1 test 3

Sheet 2
Col1 Col2
ABC ALPHA
DEF BETA
XYZ GAMMA

Sheet 3
Col1 Col2 Col3 Col4 Col5
ABC ALPHA 123 na test1
DEF BETA 456 N/A test 2

Can you please help me in getting the result.