Back to Browse

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

18.0K views
Sep 26, 2021
26:03

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 https://youtube.com/playlist?list=PL5NlUYOM2iOjRsboi_z9cHTyM7yqwWu58 -------------------------------------------------------------------------------------- To download the working files: https://drive.google.com/drive/folders/1bORjWxNNjl4pnLY9vG8zc_-GcfdJL3_B?usp=sharing -------------------------------------------------------------------------------------- To subscribe: https://www.youtube.com/channel/UCqwLHNFtrOjrOC3CnvviS1g?sub_confirmation=1 -------------------------------------------------------------------------------------- To follow on Facebook https://www.facebook.com/excelispower -------------------------------------------------------------------------------------- To follow on LinkedIn: https://www.linkedin.com/in/amratef

Download

1 formats

Video Formats

360pmp442.7 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

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