How to map tables one to many?

Question

excel

There are two xlsx files. The first one has rows with duplicate IDs (separate column) and different data, and the second one has a unique ID in each row. It is necessary to add the results of calculations over the lines with the corresponding IDs from the first one to each line in the second file. For example, specify the average, maximum and minimum there: There are

about one and a half hundred unique strings, and hundreds of thousands of repeating strings, so I would not like to do all these manipulations manually. Can you please tell me how to simplify the process?

Answer 1

Banal pivot table.
Screenshot is attached.