Converting wide-format dataset into the long-format dataset in Excel - by Atiq

This is a very helpful video on how you can convert the wide-format dataset into a long-format dataset in Excel for many countries and many years. Similar video using Stata:

More excel videos:


Please like this video. Share with your friends. Subscribe to our channel. Stay tuned!

[Learn-Coding-with-Us]

Welcome to our channel!! Please support our channel by subscribing, liking the videos, and sharing them with your friends. Your small help will tremendously benefit us to grow and promote our channel and bring incredible and knowledgeable content in the future to this channel. Thank you in advance for supporting our channel with your subscription and sharing our videos with your friends. Our channel loves to teach the content the best!!

[anthonygalka]

Oh my Gosh you are AWESOME dude!!! I was looking at so many other methods to convert from Long to Wide and this by by far the easiest way to do it! Thank you!

[akashkovuri]

you just saved hours of time. Thanks bro.

[mangomilkshakelol]

what's the shortcut for mac for 0:44 to populate the pivot table window?

[savannahwalske]

thank you for this! what would change if you were converting from long-format to wide-format?

[atiquezaman]

This is amazing, thank you. Do you have a suggestion for dealing with data with multiple header rows?

[AAFREENKHAN-gbxl]

Hi, I followed the same steps but in the end, all of the values of the variables became 1. please let me know how to correct it