Скачать или смотреть Power Query (Excel) | Multi Headers + Dynamic Rename (Dynamic Version). M code

This video will show you to transform a multi header file from a report to a structured data format. The goal is to show you how to write Power Query M code making the model dynamic. The video's main focus is to cover the multi header report transformation; however, I covered a bit more of the relevant techniques to create dynamic queries.

Topic:
0:00 - Intro
0:22 - Challenge (Unstructured Data)
0:56 - Import from the same workbook (file must be saved before import)
1:23 - Part 1 - Get the header row index
2:17 - Part 2 - Multi-Header Transformation
4:34 - Part 3 - Get the data without the header
4:53 - Part 4 - Combine both Header and Body
5:09 - Part 5 - Data Transformation: Unpivot, Split Column, Fill Down & etc
5:50 - Part 6 - Dynamic Rename
6:22 - Wrap up

Workbook:
https://docs.google.com/spreadsheets/...