Unpivot Excel Data with Power Query Step by Step
HTML-код
- Опубликовано: 15 июл 2024
- ✅ Get the sample Excel file to follow along ► 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 ► myctx.link/PQUP
More Excel Tips & Videos ► myctx.link/TipsXL
🔴 Related Excel Videos 🔴
Fix Pivot Table Refresh Errors ► • Find & Fix Pivot Table...
Clustered Stacked Pivot Chart ► • Create a Clustered Sta...
✅ Excel resources I recommend ► 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 RUclips: ruclips.net/user/contextu...
#ContexturesExcelTips
Excellent explanation!
Thank you, Rodrigo!
Brought here through your website. Great content.
Thanks
Thank you, Leandro, and I appreciate it!
Thank you for your videos. What if there are two rows to be unpivoted? I.e., scenario and period?
I’m still relatively new to power query so I’m watching as many tutorials as I can. I did one unpivot query recently so I will have to inspect that one after watching this.
It can probably be improved. Thanks for a great tutorial
Thanks, Patrick, and there's so much to learn about Power Query! But it can make complicated Excel tasks a lot easier, so it's worth the effort
thank you
You're welcome, Sviatoslav, and thanks for your comment!
hi! why the null data doesnt showing up?
Power Query automatically removes the null data. If you want to keep the nulls, there are steps in Ken Puls' video here: ruclips.net/video/-j_qCuJDWhI/видео.html