How to get a pivot table containing rows from source table, one column of which matches records in another table?

Question

excel

There is a table on 2700 lines. The key columns in it are the contract and email. There is also a second table consisting of 1000 contracts. It is necessary to somehow compare these tables and display only the rows that contain the contracts indicated in the second table. How to do it?

Answer 1

Pay attention to Excel functions. With them on your PC is a super calculator, on the shoulders of which the accounting of the world. And one of the magic functions is VLOOKUP()!
Added.
A pivot table for an average person and a person familiar with Excel is not the same thing.