Converting Panel Data from Wide to Long Format in Excel

In this video, you will learn how to reshape panel data from wide to long format

[@nguyenlinhgiang3410]

It's really helpful. Thanks for sharing!

[@maxwellpeprah1038]

The ALT, D and P shouldn't be pressed simultaneously. Rather press the ALT and D, then press P. The Wizard will show.

[@christines.3380]

I couldn’t get this to work until I saw your comment - thank you so much!!!!

[@ABCXYZ-gg4vn]

How to bring pivot table, you could have mentioned that too, many people come here for easier tutorials, don't act smart just help them in simple steps. You just opened the pivot table with some quick keyboard shortcuts and here many are confused how to open that pivot wizard box.

[@erasmusmwangi8321]

I thought so too. There must be a much simpler way of doing the same, just that we don't yet know how to.

[@cooleconometrics]

Alt+D, then press P