The best layout to present your data for quick reading may not be the best option for data analysis. This video shows how we can use Power Query in Excel to transform a multi-row header layout into a nice tabular data layout.
----------------------
Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer
LIVE CLASSES on YouTube every week: https:www// / celiaalvessolveexcel
Get access to the Live Classes EXERCISE FILES by joining our Telegram Group at https://t.me/celiaalvessolveexcel
Subscribe to my NEWSLETTER for exciting news about the Excel world: https://bit.ly/learnfromcelia
Solve & Excel Consulting - https://solveandexcel.ca
LinkedIn: / celiajordaoalves
Facebook: / solveandexcel
Twitter: @celia_excel
Instagram: @solveandexcel
#excel #msexcel #powerquery #dataanalysis #snapreports #solveandexcel #automation #reportautomation #VBA
-------------------------
#Excel #shorts #solveandexcel #microsoft365 #toronto #torontobusiness #wit #msexcel #microsoftexcel #excelreport #excelautomation #snapreports #powerquery #canada