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
Power Query Functions That Unlock Serious Automation
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
5 Power Query Tricks That Will Save You HOURS in Excel
List.Accumulate in Power Query with Practical Examples
Advanced Grouping Tricks In Power Query
APQ15 | How "each" & "_" work? | Advanced Power Query
APQ03: Advanced Power Query Video #3 - M-CODE - TABLE FUNCTIONS: transform data in multiple sheets
Power Query - Avoid "Helper Queries" (+10 Cool Tricks)
Transform nested tables in Power Query (without writing M coding) | Excel Off The Grid
APQ09: Advanced Power Query | Exact match lookup in Power Query | No Merge Queries
APQ18 | From YTD Total to Monthly Breakdown | Advanced Power Query
Power Query Secrets: Use coalesce (??) to handle null values
Using the List technique in Power Query to recombine tables
Split by Variable Columns in Power Query
4 METHODS to Filter by a List in Power Query | Excel Off The Grid
APQ16 | High speed Data Refresh | Table.Buffer | Advanced Power Query
APQ12 | Exact & Approximate Match | Lookup changing Prices & Discount | Advanced Power Query
