Excel Magic Trick 1338: Power Query: Unpivot 12 Cross Tabulated Tables into One Proper Data Set
24:00
YouTubeexcelisfun
Excel Magic Trick 1338: Power Query: Unpivot 12 Cross Tabulated Tables into One Proper Data Set
Download Files: Start File: https://excelisfun.net/files/1338Start.xlsx Finish File: https://excelisfun.net/files/1338Finished.xlsx See 2 Examples of how to use Power Query to Convert 12 Individual Cross Tabulated Tables into One Proper Data Set: 1. (00:15) Introduction 2. (01:14) Example 1: Start with 12 Cross Tabulated Excel Tables (Tables ...
29.4K viewsOct 31, 2016
Excel Basics
The Beginner's Guide to Excel - Excel Basics Tutorial
21:47
The Beginner's Guide to Excel - Excel Basics Tutorial
YouTubeTechnology for Teachers and
21.4M viewsApr 24, 2017
Excel Tutorial for Beginners
16:17
Excel Tutorial for Beginners
YouTubeKevin Stratvert
6M viewsJul 25, 2023
Master Excel Basics in NO TIME
46:38
Master Excel Basics in NO TIME
YouTubeTeacher's Tech
357.1K viewsNov 13, 2023
Top videos
Excel Dynamic Arrays: Column of Records into Proper Data Set (Excel Magic Trick 1531)
Excel Dynamic Arrays: Column of Records into Proper Data Set (Excel Magic Trick 1531)
YouTubeexcelisfun
12.4K viewsNov 11, 2018
Excel Magic Trick 1293: Single Cell "Lookup Adding" w Proper Data Set for Myers-Briggs Test Score
6:24
Excel Magic Trick 1293: Single Cell "Lookup Adding" w Proper Data Set for Myers-Briggs Test Score
YouTubeexcelisfun
6.1K viewsMar 18, 2016
Excel Magic Trick 1223: Power Query UnPivot Feature to Create Proper Data Set For Sales & Grade Data
5:44
Excel Magic Trick 1223: Power Query UnPivot Feature to Create Proper Data Set For Sales & Grade Data
YouTubeexcelisfun
12K viewsAug 10, 2015
Excel Formulas and Functions
OMG 🔥 Microsoft Excel 30 Formulas | Excel Functions and Formulas
12:00
OMG 🔥 Microsoft Excel 30 Formulas | Excel Functions and Formulas
YouTubeTime to Office
5.1K views6 months ago
Excel for Beginners: Master Formulas, Functions & Cell References
14:03
Excel for Beginners: Master Formulas, Functions & Cell References
YouTubeTeacher's Tech
18.5K views7 months ago
Top 15 Excel Functions Everyone Needs to Know
1:03:34
Top 15 Excel Functions Everyone Needs to Know
YouTubeSimon Sez IT
10.6K viewsFeb 4, 2025
Excel Dynamic Arrays: Column of Records into Proper Data Set (Excel Magic Trick 1531)
Excel Dynamic Arrays: Column of Records into Proper Data Set (Exc…
12.4K viewsNov 11, 2018
YouTubeexcelisfun
Excel Magic Trick 1293: Single Cell "Lookup Adding" w Proper Data Set for Myers-Briggs Test Score
6:24
Excel Magic Trick 1293: Single Cell "Lookup Adding" w Proper Data S…
6.1K viewsMar 18, 2016
YouTubeexcelisfun
Excel Magic Trick 1223: Power Query UnPivot Feature to Create Proper Data Set For Sales & Grade Data
5:44
Excel Magic Trick 1223: Power Query UnPivot Feature to Create P…
12K viewsAug 10, 2015
YouTubeexcelisfun
TOCOL, DROP, EXPAND Array Functions to UnPivot Data into Proper Table. Excel Magic Trick 1785
10:20
TOCOL, DROP, EXPAND Array Functions to UnPivot Data into Pr…
20.9K viewsMar 24, 2022
YouTubeexcelisfun
Power Query Unpivot with 2 Column Variables? Bad Data Into Good Data. Excel Magic Trick 1916
10:10
Power Query Unpivot with 2 Column Variables? Bad Data Into Good Da…
4.6K views4 months ago
YouTubeexcelisfun
50 ADVANCED Excel Tricks: Master Spreadsheets & Boost Productivity (2025)
3:26:36
50 ADVANCED Excel Tricks: Master Spreadsheets & Boost Productivit…
6.3K views5 months ago
YouTubeExcel (A-Z)
Excel Magic Trick 382: Match Two Lists, Extract Column Data From Each List
6:26
Excel Magic Trick 382: Match Two Lists, Extract Column Data From E…
286.8K viewsSep 10, 2009
YouTubeexcelisfun
18:35
14 New Excel Worksheet Functions That Will Blow Your Mind! Excel M…
37.1K viewsMar 19, 2022
YouTubeexcelisfun
0:21
Excel Magic Trick Clean Names in 2 Seconds with PROPER Function!, …
2.4K views3 weeks ago
YouTubeAN EXCEL
15:07
12 Excel Tricks That Will Change the Way You Work
4.9K views3 months ago
YouTubeMy Live Support
15:07
Top 6 Excel Tricks for Smart Automation! ⚡📊
17.2K views4 months ago
YouTubeVedakarna
12:11
FILTER function AND Logical Test made Easy with BYROW & AND fu…
21.2K views5 months ago
YouTubeexcelisfun
0:22
Clean Messy Data Instantly with TRIM Formula! ⚡ | Excel Magic Trick
68.6K views5 months ago
YouTubeMr GK
3:38
WRAPCOL & SORTBY Array Functions to Pivot A Table. "Robu…
9K viewsMar 23, 2022
YouTubeexcelisfun
13:09
This Excel Trick Changes Everything You Know About SUM!
66.1K views4 months ago
YouTubeGoodly
0:36
Excel Magic Tricks || Data Validation in Excel || Drop Down List in Excel
4.2K views4 months ago
YouTubeDK TECH
3:28
Two Way Lookup with XLOOKUP & Summary Report with SUMIFS. Ex…
8.2K viewsOct 30, 2022
YouTubeexcelisfun
13:29
PivotTables Instantly Update When Source Data Change, Just Like Fo…
51.6K views7 months ago
YouTubeexcelisfun
0:19
Flash Fill Excel Trick 🔥 | Excel Magic 2025 #tipsandtricks #excelformula
24.9K views6 months ago
YouTubeSuper Creation Tips
0:33
EXCEL Magic Trick Revealed with Flash Fill!
7.2K views5 months ago
YouTubeBright Minds Hub
0:47
Dynamic Icon Value in Excel – Magic Trick
2.7K views3 months ago
YouTubeGyan On Tube
1:09
Excel Magic Trick Using textspilt and Sum Function
960 views3 months ago
YouTubeNew Tech Mart
18:46
6 Essential Excel Magic Tricks for Office Work | Advanced Excel Tip…
21.6K viewsNov 11, 2024
YouTubeMy Live Support
16:41
6 Essential Excel Magic Tricks for Office Work | Bonus Tips🔥
2.3K viewsNov 22, 2024
YouTubeMy Live Support
8:08
Create Excel Database and Data Entry Form. Excel Magic Trick 1690.
927.6K viewsSep 14, 2020
YouTubeexcelisfun
2:18
Excel Magic Trick 643: IF Function to Pull Data From A Different Colu…
496.1K viewsJul 6, 2010
YouTubeexcelisfun
3:00
Why Data Analysis Needs Proper Tables and Power Query’s UnPivo…
6.1K views11 months ago
YouTubeexcelisfun
5:39
Highlight Active Cell in Excel (Excel Magic Trick # 1)
121.1K viewsDec 26, 2018
YouTubeMicrosoft Office Tutorials
11:21
Excel Magic Trick 1263: Power Query M Code: 10 Cross Tabulate…
21.6K viewsJan 25, 2016
YouTubeexcelisfun
See more videos
Static thumbnail place holder