filmov
tv
Promote headers in nested tables before expanding columns | Power Query | Excel Off The Grid
Показать описание
★ Want to automate Excel? Check out our training academy ★
★ Get the example file ★
★ Check out the dynamic column expand post ★
★ About this video ★
In Power Query, promoting headers of nested tables before expanding columns leads to fewer and easier transformations. However, these options are not available in the user interface. Therefore, we need to make a few changes to the M code ourselves.
This video shows two ways to promote headers before expanding the columns.
0:00 Introduction
0:25 Example & problem
2:30 Promote nested Table headers - Excel files
3:34 Promote nested Table headers - Other file types
6:50 Dynamic column expand method
7:19 Wrap-up
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
★ Where to find Excel Off The Grid ★
#MsExcel
★ Get the example file ★
★ Check out the dynamic column expand post ★
★ About this video ★
In Power Query, promoting headers of nested tables before expanding columns leads to fewer and easier transformations. However, these options are not available in the user interface. Therefore, we need to make a few changes to the M code ourselves.
This video shows two ways to promote headers before expanding the columns.
0:00 Introduction
0:25 Example & problem
2:30 Promote nested Table headers - Excel files
3:34 Promote nested Table headers - Other file types
6:50 Dynamic column expand method
7:19 Wrap-up
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
★ Where to find Excel Off The Grid ★
#MsExcel
0:07:34
Promote headers in nested tables before expanding columns | Power Query | Excel Off The Grid
0:12:37
Power Query - Advanced Transformation of Nested Tables
0:11:01
Replace column names of nested tables using Power Query | Excel Off The Grid
0:06:35
Power Query Tips: Promoting Headers for All Files using Power Query
0:10:22
Automatically Remove Top Junk Rows & Combine Data from Multiple Excel Files
0:12:29
Combine Data from Multiple Excel Files | Most Dynamic Method (Dynamic Columns & Sheets)
0:40:38
You'll Love This Technique When Working With Nested Tables! - Saturday With Power Query
0:05:19
Advanced Power Query - Unpivot Columns with Multiple Headers
0:08:14
Transform nested tables in Power Query (without writing M coding) | Excel Off The Grid
0:01:22
Excel.Workbook - Promote Headers
0:06:34
Unpivot Cross Tabulated Data with Multiple Headers and Columns
0:12:58
Filter Nested Tables before Expanding in Power Query
0:10:42
Excel Power Query Tutorial - Transforming Nested Tables
0:12:35
How to Combine Multiple Files with Inconsistent Column Headers into a Single Sheet
0:11:46
How To Transform Nested Tables & Then Combine Them - Power Query
0:18:54
Untangling Nested Headers in Power Query - Portland Power BI UG
1:31:40
Dynamically expanding specific columns & Optimizing code with nested let - #SaturdayWithPowerQue...
0:05:13
PQ - Working with Double Headers
0:14:55
Practical Power Query: Unpivot Nested Tables
0:02:20
Remove Top Rows & Promote Headers - Simple Toolbar Transformations - Power Query Jumpstarter
1:02:33
Let's add a column to nested tables - Saturday With Power Query
0:02:08
Easy fix for promoting headers when name can change issue in PowerQuery- no complex coding
0:07:03
How to Unpivot Multi Header Data in Power Query | Part-02 (Super Easy)
0:18:32
Combine Data from Multiple Excel Files with Inconsistent Column Names
Комментарии