How to reshape wide panel data to long panel data in excel

In this video, I show how to convert wide panel data to long panel data in excel. I use the dataset from Prowess database. This database is popularly used for conducting research on Indian firms. We mainly use powerquery and xlookup function in excel for our objective. To follow me on different platforms, click the following link: linktr.ee/kamal_krishna

• #education
• #wide_panel_data
• #long_panel_data
• #panel_data
• #reshape
• #excel
• #prowess
• #prowess_database
• #financial_research
• #research
• #analysis
• #power_query
• #xlookup