Dear all,
I am currently working on my MSc thesis in Finance and I use data from Orbis. I need to construct a panel data set to obtain elasticities with a regression. However, my data format is not right at the moment. Currently, my dataset has a lot of different columns with one observation for each firm and I have different variables for the same variable over time, for example EBITDA_2018, EBITDA_2017, and EBITDA_2016. I want to know if it possible and if so, how I change my dataset so that these three variables are merged to just one variable called EBITDA ?

Thanks in advance!
Kind regards,
Romy