Hello,
I am trying to append the data from multiple data sets.
What i have is time series data for 1500 companies on 5 different variables. So each sheet is the data for a specific variable like EPS for example. The column headers of each sheet is the company names and the data points are quarterly.
variable 1 variable 2
Quarter F1 F2 F3 Quarter F1 F2 F3
Q1 1.1 1.2 1.3 Q1 1.1 1.2 1.3
Q2 1.1 1.2 1.3 Q2 1.1 1.2 1.3
Q3 1.1 1.2 1.3 Q3 1.1 1.2 1.3
What i need is a panel data where the column headers would be: Company, Date, EPS, variable 2, variable 3 etc.
Firm Quarter Variable 1 variable 2
F1 Q1 1.1 1.1
F1 Q2 1.1 1.1
F2 Q1 1.2 1.2
F2 Q2 1.2 1.2
F3 Q1 1.3 1.3
F3 Q2 1.3 1.3
ETC...
I just need direction or ideas on the most efficient way to append this data.
please help!!
Thank You!
Bookmarks