How to transform stacked data from Excel with Power Query
Stacked data can be useful if you want to print it on paper or as a PDF for a presentation, for example. But whatever the reason for this format, stacked data is extremely difficult to process mechanically. In this video, I'll show you how to transform stacked data from Excel into dataset format using Power Query.
📊 SAMPLE FILES 📊
The sample files used are available free of charge for subscribers to my newsletter: http://eepurl.com/cmkOEz
🎓 VIDEO COURSE 🎓
My comprehensive Power Query beginner's course with 160+ videos – everything about data import and automation:
https://myablefy.com/s/ssbi-blog/powe...
👨🎓 TRAININGS 👩🎓
My Power BI online training courses https://ssbi-blog.de/power-bi-schulungen
🥷 CONSULTING 🥷
Want to book a consultation? Click here: https://calendly.com/ssbi-blog/15min
🙋♂️ CONTACT 🙋♂️
Website: https://ssbi-blog.de/
LinkedIn: / lars-schreiber-power-bi
Twitter: / schreiberlars
🤿 SETUP 🤿
https://kit.co/LarsSchreiber/office-s...