filmov
tv
Transforming Nested Tables - Saturday With Power Query
Показать описание
Join me this Saturday for another Power Query session 🪄
Today we saw how to consolidate different files, with different number of sheets, layouts, and DIFFERENT columns. All by transforming nested tables.
Files available here (right click & select download):
Video with a custom function as solution:
Thanks for watching 😊
#MSExcel #PowerQuery #SaturdayWithPowerQuery
Today we saw how to consolidate different files, with different number of sheets, layouts, and DIFFERENT columns. All by transforming nested tables.
Files available here (right click & select download):
Video with a custom function as solution:
Thanks for watching 😊
#MSExcel #PowerQuery #SaturdayWithPowerQuery
0:57:52
Transforming Nested Tables - Saturday With Power Query
0:12:37
Power Query - Advanced Transformation of Nested Tables
0:10:42
Excel Power Query Tutorial - Transforming Nested Tables
0:40:38
You'll Love This Technique When Working With Nested Tables! - Saturday With Power Query
0:08:14
Transform nested tables in Power Query (without writing M coding) | Excel Off The Grid
0:51:04
19 ALEJANDRA HORVATH Power Query Transforming nested tables
1:02:33
Let's add a column to nested tables - Saturday With Power Query
0:06:20
Transforming A Column & Filtering The Nested Tables Inside - My Favourite Tips Fr Live Sessions ...
0:11:46
How To Transform Nested Tables & Then Combine Them - Power Query
0:07:15
Expand columns with values and nested tables in Power Query
0:12:58
Filter Nested Tables before Expanding in Power Query
0:05:16
Power Query - Filter Nested Table Before Expanding
0:38:06
How I use Modulo & Integer-Divide In Nested Tables - #SaturdayWithPowerQuery
0:54:37
Nested let & in - Saturday With Power Query
0:07:22
Calculate Inside Nested Tables | Power Query | Excel
0:06:36
Get Data from Nested Table and Concatenate Items using Power Query
1:31:40
Dynamically expanding specific columns & Optimizing code with nested let - #SaturdayWithPowerQue...
0:03:27
Modify Whole Table Using Nested List.Transform() in Power Query
0:14:55
Practical Power Query: Unpivot Nested Tables
0:55:29
Intermediate-Advanced - Data Cleaning Techniques With Power Query - Nested Tables & Pdf files
0:11:01
Replace column names of nested tables using Power Query | Excel Off The Grid
0:05:04
Iterating functions w/ nested data - case study: transform excel workbooks & worksheets to tidy ...
0:06:10
Adding the file name to nested tables
0:06:44
Tutorial 54 : Nested Table as Database Object
Комментарии