How to use Excel Power Query Unpivot to fix 4 common data layouts, so your data is in the correct tabular layout to work with functions and PivotTables the way they were designed. 🔻 STEP BY STEP INSTRUCTIONS EXCEL FILE DOWNLOAD: 🎓 LEARN MORE in my Excel courses: 🔔 SUBSCRIBE if you’d like more tips and tutorials like this. 💬 Please leave me a COMMENT. I read them all! 🧟‍♀️ CONNECT with Mynda on LinkedIn: 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 💬 EXCEL QUESTIONS: Get help on our Excel Forum: