Uploaded June 2023 | Updated November 2026, 3 hours ago
Unstack your data quickly and efficiently with this trick. Watch the full thing for surprises!
β± IN THE VIDEO
==============
0:00 - Unstacking with WRAP functions
1:03 - Unstacking data when it is from a TEXT file
3:02 - Unstacking a folder full of files
πΊ WATCH NEXT
==============
Combine a folder of Excel (or Text) files - youtu.be/SGzegma9bdY
Get data from PDFs - youtu.be/5I0pnj_-LLA
Combine data from all sheets - youtu.be/k_ugshJ4wIw
Combine data when headers don't match - youtu.be/ECtJQDc8uF8
SAMPLE FILE π
=============
Use this file to practice the unstack concepts - chandoo.org/wp/wp-content/uploads/2023/06/unstack-data.xlsx
~
What does the data analyst call a loaf of bread? π
bUNSTACK π€£
Unstack your data quickly and efficiently with this trick. Watch the full thing for surprises!
β± IN THE VIDEO
==============
0:00 - Unstacking with WRAP functions
1:03 - Unstacking data when it is from a TEXT file
3:02 - Unstacking a folder full of files
πΊ WATCH NEXT
==============
Combine a folder of Excel (or Text) files - youtu.be/SGzegma9bdY
Get data from PDFs - youtu.be/5I0pnj_-LLA
Combine data from all sheets - youtu.be/k_ugshJ4wIw
Combine data when headers don't match - youtu.be/ECtJQDc8uF8
SAMPLE FILE π
=============
Use this file to practice the unstack concepts - chandoo.org/wp/wp-content/uploads/2023/06/unstack-data.xlsx
~
What does the data analyst call a loaf of bread? π
bUNSTACK π€£










