How to transform data with multi-row headers into tabular format with Power Query

Опубликовано: 23 Февраль 2025
на канале: Celia Alves - Solve & Excel
2,859
37

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