APQ13 | M-Code Functions | List.Split | List.Zip | Advanced Power Query

#excel #exceltutorial #powerquery #m_code --------------------------------------------------------------------- Visit the website: www.aaa-power.net --------------------------------------------------------------------- Chapters: 0:00 Intro 0:49 Example Overview 1:47 Solution: M-Code Functions (List.Split - List.Zip - Table.FromColumns) 8:42 Solution: Worksheet Functions (WRAPROWS - VSTACK) 11:40 Close --------------------------------------------------------------------- To watch the full Playlist    • Advanced Power Query   --------------------------------------------------------------------- To download the working files: https://drive.google.com/drive/folder... --------------------------------------------------------------------- To subscribe:    / @aaaexcelenglish   --------------------------------------------------------------------- To follow on Facebook:   / excelispower   --------------------------------------------------------------------- To follow on LinkedIn:   / amratef  

APQ14 | The easiest way to master “M” functions | Advanced Power Query
▶︎

APQ14 | The easiest way to master “M” functions | Advanced Power Query

APQ11 | Merge Queries - Next Level | Merge | M-Code | Custom Column | Records | Advanced Power Query
▶︎

APQ11 | Merge Queries - Next Level | Merge | M-Code | Custom Column | Records | Advanced Power Query

List.Buffer: This One Power Query Function Can Speed Up Your Refresh
▶︎

List.Buffer: This One Power Query Function Can Speed Up Your Refresh

APQ15 | How "each" & "_" work? | Advanced Power Query
▶︎

APQ15 | How "each" & "_" work? | Advanced Power Query

Promote Multi-Row Headers with One Custom Function in Power Query M
▶︎

Promote Multi-Row Headers with One Custom Function in Power Query M

Power Query - Avoid "Helper Queries" (+10 Cool Tricks)
▶︎

Power Query - Avoid "Helper Queries" (+10 Cool Tricks)

List.Generate in Power Query - Tutorial with Easy Examples
▶︎

List.Generate in Power Query - Tutorial with Easy Examples

The Fastest Replace Values method using a list in Power Query
▶︎

The Fastest Replace Values method using a list in Power Query

APQ18 | From YTD Total to Monthly Breakdown | Advanced Power Query
▶︎

APQ18 | From YTD Total to Monthly Breakdown | Advanced Power Query

CHOSEN ONE! SOMEONE IN A SUIT JUST ASKED "WHO TRAINED THEM?" ...NOBODY DID. THAT'S THE MYSTERY
▶︎

CHOSEN ONE! SOMEONE IN A SUIT JUST ASKED "WHO TRAINED THEM?" ...NOBODY DID. THAT'S THE MYSTERY

APQ03: Advanced Power Query Video #3 - M-CODE - TABLE FUNCTIONS: transform data in multiple sheets
▶︎

APQ03: Advanced Power Query Video #3 - M-CODE - TABLE FUNCTIONS: transform data in multiple sheets

List.Accumulate in Power Query with Practical Examples
▶︎

List.Accumulate in Power Query with Practical Examples

Power Query - Unlimited Formulas in 1 Step
▶︎

Power Query - Unlimited Formulas in 1 Step

Musica para trabajar activo y alegre - Música Alegre para en Tiendas, Cafés | Deep House Mix 2026
▶︎

Musica para trabajar activo y alegre - Música Alegre para en Tiendas, Cafés | Deep House Mix 2026

4 METHODS to Filter by a List in Power Query | Excel Off The Grid
▶︎

4 METHODS to Filter by a List in Power Query | Excel Off The Grid

APQ08: Power Query List Functions - Bulk Replace values in a table using a helper table
▶︎

APQ08: Power Query List Functions - Bulk Replace values in a table using a helper table

Nested Lists in Power Query: You’ll Wish You Knew This Sooner
▶︎

Nested Lists in Power Query: You’ll Wish You Knew This Sooner

Advanced Unpivoting Tricks in Power Query
▶︎

Advanced Unpivoting Tricks in Power Query

MORNING PRAYER | Surrender Your Family to God with Faith and Walk this Day in His Peace and Prote...
▶︎

MORNING PRAYER | Surrender Your Family to God with Faith and Walk this Day in His Peace and Prote...

APQ09: Advanced Power Query | Exact match lookup in Power Query | No Merge Queries
▶︎

APQ09: Advanced Power Query | Exact match lookup in Power Query | No Merge Queries