If you are in finance research area, and you are using panel data, the most annoying part is stacking/transpose your time series into panel data. Hereby, I give you the macros in excel (even though I know many software such Tableau can do it faster) to do in a click.
Yet, when you want to run it, adjust it with the number of your column. Mine is 6, and the data that has to be stacked/transposed is from column 2. Therefore, the i = 2 to 6.
Copy paste this to your macros (open your excel –> view –> macros –>view macros –> create –> copy paste –> run)
Dim rng As Range
For i = 2 To 6
Set rng = Range(Cells(1, i), Cells(1, i).End(xlDown))
rng.Cut Cells(Rows.Count, 2).End(xlUp)(2)