Forum Discussion

fx_jvs's avatar
fx_jvs
Copper Contributor
Jun 18, 2022
Solved

Paneldata Data Transpose

Hello guys,   I have a problem with my linear panel data set. As shown in Figure 1, I have 12 different metrics that I want to examine in a panel data analysis with 108 companies over the course of...
BI & Data Analysis
excel
  • dscheikey's avatar
    dscheikey
    Jun 18, 2022

    fx_jvs 

    I hope I have understood your problem correctly. I have shared an example file with you in my Onedrive. Here you can see how to get the rows below each other in a column.

     

    Example 

     

    I hope this helps you and you get further. Otherwise, please contact me again.

dscheikey's avatar
dscheikey
Bronze Contributor
Jun 18, 2022

fx_jvs 

I hope I have understood your problem correctly. I have shared an example file with you in my Onedrive. Here you can see how to get the rows below each other in a column.

 

Example 

 

I hope this helps you and you get further. Otherwise, please contact me again.

Resources