Тёмный

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

Learn Coding with Us
Подписаться 447
Просмотров 17 тыс.
50% 1

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:
Converting wide-format dataset into the long-format dataset in Stata: • Converting wide-format...
More excel videos:
-How to remove duplicates using Excel : • How to remove duplicat...
- How to spilt Words or Delimited data into New Rows using Power Query Editor in Excel: • How to spilt Words or ...
-How to use XLOOKUP function in Excel: • How to use XLOOKUP fun...
Please like this video. Share with your friends. Subscribe to our channel. Stay tuned!

Опубликовано:

 

27 июн 2021

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 22   
@Learn-Coding-with-Us
@Learn-Coding-with-Us 3 года назад
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!!
@anthonygalka4326
@anthonygalka4326 Год назад
Oh my Gosh you are AWESOME dude!!! I was looking at so many other methods to convert from Long to Wide and this by far..... by far the easiest way to do it! Thank you!
@Learn-Coding-with-Us
@Learn-Coding-with-Us Год назад
You are most welcome!
@rashid.alkhadhuri
@rashid.alkhadhuri 2 месяца назад
You are a life saver
@mubashirgc
@mubashirgc 5 месяцев назад
wonderful
@Learn-Coding-with-Us
@Learn-Coding-with-Us 5 месяцев назад
You are most welcome!
@yonghyeon123
@yonghyeon123 Год назад
This just saved hours of work. GG
@akashkovuri4202
@akashkovuri4202 Год назад
you just saved hours of time. Thanks bro.
@Learn-Coding-with-Us
@Learn-Coding-with-Us 5 месяцев назад
You are most welcome!
@thalesromao2239
@thalesromao2239 10 месяцев назад
Tks Man
@savannahwalske1071
@savannahwalske1071 2 месяца назад
thank you for this! what would change if you were converting from long-format to wide-format?
@stephan8345
@stephan8345 Год назад
Thanks, amazing!
@Learn-Coding-with-Us
@Learn-Coding-with-Us 5 месяцев назад
You are most welcome!
@atiquezaman7128
@atiquezaman7128 9 месяцев назад
This is amazing, thank you. Do you have a suggestion for dealing with data with multiple header rows?
@mariusvdb7048
@mariusvdb7048 Год назад
My man
@mangomilkshakelol
@mangomilkshakelol Год назад
what's the shortcut for mac for 0:44 to populate the pivot table window?
@sputnijk
@sputnijk 2 года назад
thanks atiq
@Learn-Coding-with-Us
@Learn-Coding-with-Us 2 года назад
You are most welcome.
@rcrajatraj
@rcrajatraj 3 года назад
Nice video bro..
@Learn-Coding-with-Us
@Learn-Coding-with-Us 3 года назад
Thanks.
@AAFREENKHAN-gb8xl
@AAFREENKHAN-gb8xl Месяц назад
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
@NR-rf2bg
@NR-rf2bg 3 месяца назад
what about mac bro
Далее
Spreadsheet Reshape Excel Data Sets for Analysis
5:01
Stata: Reshaping Data using World Bank Open Data Sets
11:59
Converting wide data to long in Excel & Google Sheets
12:19
Long vs wide data formats, plus unit of analysis
8:31