How to combine 2 tables by column?

Question

excel

There is a Sheet1 table with the Phone, Column1_1, Column1_2 columns
and a Sheet2 table with the Phone, Column2_1, Column2_2 columns.
The Phone values ​​of both tables sometimes intersect, that is, in Sheet1 on line 30 it can be phone = 79141111111, and the same number can be in Sheet2 on line 50 .
How can these tables be combined into one Sheet3 with columns Phone, Column1_1, Column1_2, Column2_1, Column2_2 in such a way that the intersecting numbers retain the corresponding values ​​of all columns.

Answer 1

1. Merge Phone from Sheet1 and Sheet2 to remove duplicates.
   
2. Phone list placed on Sheet3.
   
3. Use ВПР().