APQ03: Advanced Power Query Video #3 - M-CODE - TABLE FUNCTIONS: transform data in multiple sheets
Автор: AAA Excel’s Power
Загружено: 2021-09-26
Просмотров: 16644
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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
