Power Query Unpivot - fix 4 common data layouts (incl. workbook)

  Рет қаралды 235,508

MyOnlineTrainingHub

MyOnlineTrainingHub

Күн бұрын

Пікірлер: 633
Excel Features That Will Set You Apart in 2025
11:30
Excel Features That Will Set You Apart in 2025
MyOnlineTrainingHub
Рет қаралды 18 М.
How to easily automate boring Excel tasks with Power Query!
17:10
How to easily automate boring Excel tasks with Power Query!
MyOnlineTrainingHub
Рет қаралды 1,6 МЛН
Don’t Choose The Wrong Box 😱
00:41
Don’t Choose The Wrong Box 😱
Topper Guild
Рет қаралды 62 МЛН
Enceinte et en Bazard: Les Chroniques du Nettoyage ! 🚽✨
00:21
Enceinte et en Bazard: Les Chroniques du Nettoyage ! 🚽✨
Two More French
Рет қаралды 42 МЛН
REAL or FAKE? #beatbox #tiktok
01:03
REAL or FAKE? #beatbox #tiktok
BeatboxJCOP
Рет қаралды 18 МЛН
“Don’t stop the chances.”
00:44
“Don’t stop the chances.”
ISSEI / いっせい
Рет қаралды 62 МЛН
7 Advanced PivotTable Techniques That Feel Like Cheating
16:07
7 Advanced PivotTable Techniques That Feel Like Cheating
MyOnlineTrainingHub
Рет қаралды 103 М.
Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)
19:04
Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)
Maven Analytics
Рет қаралды 125 М.
3 Methods to unpivot in Excel using Power Query | Excel Off The Grid
11:38
3 Methods to unpivot in Excel using Power Query | Excel Off The Grid
Excel Off The Grid
Рет қаралды 8 М.
Get Multiple Files Containing Multiple Sheets with Power Query
8:49
Get Multiple Files Containing Multiple Sheets with Power Query
MyOnlineTrainingHub
Рет қаралды 435 М.
The Excel Tool That Does What PivotTables Can’t (File Included)
13:59
The Excel Tool That Does What PivotTables Can’t (File Included)
MyOnlineTrainingHub
Рет қаралды 223 М.
The Excel Functions Almost Everyone Overlooks (Better Than SUMIFS)
10:29
The Excel Functions Almost Everyone Overlooks (Better Than SUMIFS)
MyOnlineTrainingHub
Рет қаралды 120 М.
Power Query Convert Columns to Rows for groups and expand columns dynamically in 2 ways
15:46
Power Query Convert Columns to Rows for groups and expand columns dynamically in 2 ways
Access Analytic
Рет қаралды 48 М.
Excel XLOOKUP Function Definitive Guide - Replaces VLOOKUP, INDEX&MATCH & HLOOKUP
20:48
Excel XLOOKUP Function Definitive Guide - Replaces VLOOKUP, INDEX&MATCH & HLOOKUP
MyOnlineTrainingHub
Рет қаралды 315 М.
How to Merge Excel Files with Different Headers in Power Query | List.Accumulate
17:04
How to Merge Excel Files with Different Headers in Power Query | List.Accumulate
Leila Gharani
Рет қаралды 224 М.
When Should You Use the Hash Sign in Excel Formulas?
10:53
When Should You Use the Hash Sign in Excel Formulas?
Leila Gharani
Рет қаралды 1,1 МЛН
Don’t Choose The Wrong Box 😱
00:41
Don’t Choose The Wrong Box 😱
Topper Guild
Рет қаралды 62 МЛН