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

Опубликовано: 30 Июнь 2026
на канале: AAA Excel's Power

18,306

607

Chapters:
--------------------------------------------------------------------------------------
Intro: 0:00
3:51 Transform Data Table
6:29 Table.FillDown
9:16 Table.Skip
11:47 Table.PromoteHeaders
13:50 Table.UnpivotOtherColumns
16:58 Get Data From Headers
18:02 Table.FirstN
19:20 Table.SelectColumns
21:00 Table.Trnaspose
25:49 Closing
--------------------------------------------------------------------------------------
To watch the full playlist
   • Advanced Power Query
--------------------------------------------------------------------------------------
To download the working files:
https://drive.google.com/drive/folder...
--------------------------------------------------------------------------------------
To subscribe:
   / @aaaexcel
--------------------------------------------------------------------------------------
To follow on Facebook
  / excelispower
--------------------------------------------------------------------------------------
To follow on LinkedIn:
  / amratef