How to unpivot data with repeated column groups into tabular layout with Power Query in Excel

Опубликовано: 11 Февраль 2025
на канале: Celia Alves - Solve & Excel

3,921

UNPIVOT is one of the most potent tools in Power Query. Pivoted data comes in all types of shapes, and some are challenging. Watch one not-too-complex example in this video to understand some of the workaround techniques you can use to solve each case.

----------------------

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