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

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//youtube.com/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: https://www.linkedin.com/in/celiajordaoalves
Facebook: https://www.facebook.com/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