Reorganize a data set

Hi everybody,

I am currently writing my master thesis, for this I need to perform data analysis.
The data team of my university has provided me with a data set for several variables for thousands of companies, through out several years.

Very handy, however the organization of the data makes it impossible for me to use it.

Therefore I want to reorganize the data, I started by doing it manually, but after 4 hours I am hoping to find an easier method.

To explain what I want to do, I have included an attatchment. I hope the colours inserted make my intentions clear..

I expect it should not be to complicated, but I am just a beginner in excel and my skills are therefore very limited.

Hopefully someone can help me with this!

Thanks!!