Link different csv files into a pivot table through common element

I have several Formula 1 csv files. One of them has a list of driver ids with their driver name, another one has a list of circuit ids with their circuit name and another one has a list of race ids with their specific races. The final one has the results of different races and can be linked to the others through the ids. I need a pivot table that has the driver names at the top, the race names to the left and has each driver's result in a specific race. How can I put the data associated with the ids as the value while still putting the names in the columns and rows? There's some other things like filtering by year and conditional formatting, but I can do those.

The dataset is kaggle/datasets/rohanrao/formula-1-world-championship-1950-2020 (kaggle is a com domain but I removed the dot com because I can't post links) if that's helpful. I'm only using a few of the files for this.