Unpivot Excel Data with Power Query Step by Step
✅ Get the sample Excel file to follow along ► https://myctx.link/PQUP
🔵 Unpivot Excel data, if needed, to change from horizontal report layout to normalized column layout. This step-by-step guide shows how to unpivot using Power Query. This unpivot technique creates better source data for building flexible pivot tables.
💡 Related Links 💡
Unpivot Excel Data with Power Query ► https://myctx.link/PQUP
More Excel Tips & Videos ► https://myctx.link/TipsXL
🔴 Related Excel Videos 🔴
Fix Pivot Table Refresh Errors ► • Find & Fix Pivot Table Errors with Free Ex...
Clustered Stacked Pivot Chart ► • Create a Clustered Stacked Column Pivot Ch...
✅ Excel resources I recommend ► https://myctx.link/xlpick
⏰ Video Timeline ⏰
00:00 Introduction
00:27 Named Excel Table
01:24 Start Power Query
02:02 Rename Query
02:19 Delete Step
02:42 Remove Column
02:57 Unpivot Data
03:31 Rename Columns
03:50 Detect Data Type
05:10 Load Data
05:41 Refresh Data
05:59 Get the Sample File
🔶 Instructor: Debra Dalgleish, Contextures Inc.
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu...
#ContexturesExcelTips