Hello everyone!
I'm currrently doing my master's dissertation (in Finance) and would like to ask you for some help regarding the shaping of the data I've collected. I'm doing a panel data analysis and therefore have data for several companies across time.
Attached goes a sample file so you can better visualise how I've collected the data and how i want to reshape it. The green tabs are some of the variables I'll use in my analysis, with each tab having info on the respective variable for several companies across several years.
I need to take this data and reshape it into panel data form, as in the first tab (variables in columns and companies and years in lines). I'm looking for a way (either through formulas, macros,...) to do that relatively fast, given that doing it by hand (copying and pasting with transpose, which is the first idea I came up with) is simply not feasible time wise.
I'd really appreciate any help you could give me, since it'll probably save me a lot of time and trouble.
Thank you!
Bookmarks