How to transpose your rich data into panel (Data Stacking / Transpose)

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.

Happy trying

Copy paste this to your macros (open your excel –> view –> macros –>view macros –> create –> copy paste –> run)

Continue reading