M365 Show -  Microsoft 365 Digital Workplace Daily

M365 Show - Microsoft 365 Digital Workplace Daily

Share this post

M365 Show -  Microsoft 365 Digital Workplace Daily
M365 Show - Microsoft 365 Digital Workplace Daily
Unpivot Multiple Column Groups in Power Query with Step by Step Tutorial
Microsoft Data Pulse: Power BI, Fabric, Purview

Unpivot Multiple Column Groups in Power Query with Step by Step Tutorial

Mirko Peters - M365 Specialist's avatar
Mirko Peters - M365 Specialist
Jun 19, 2025
∙ Paid

Share this post

M365 Show -  Microsoft 365 Digital Workplace Daily
M365 Show - Microsoft 365 Digital Workplace Daily
Unpivot Multiple Column Groups in Power Query with Step by Step Tutorial
Share

You often work with complex data in excel, especially when you see multiple headers and column groups. When you unpivot multiple column groups, you make your data much easier to analyze. Power query gives you the power to quickly reshape your excel data, even if you have a total row or a summary at the bottom. You can follow a clear, step-by-step approa…

Keep reading with a 7-day free trial

Subscribe to M365 Show - Microsoft 365 Digital Workplace Daily to keep reading this post and get 7 days of free access to the full post archives.

Already a paid subscriber? Sign in
© 2025 Mirko Peters
Publisher Privacy ∙ Publisher Terms
Substack
Privacy ∙ Terms ∙ Collection notice
Start writingGet the app
Substack is the home for great culture

Share