Van: Gašper Kamenšek - ExcelUnplugged
Duur: 9:49
Hoe zet je een "draaitabel" met twee titelrijen en twee titelkolommen om naar een standaard tabel.
Double Header rows in Excel. The source of so much heartache. For this example, we will take it a step further as we will also have two header columns, and of course, our end goal is to have a normalized table. This video will feature an advanced Power Query tutorial on dealing with double header rows in Power Query. The question does make sense since Power Query only allows for one header row, so we will use many transformation tricks to get to the final result. Enjoy!
This tutorial was made using Excel 365, but the techniques shown apply to all Excel versions containing Power Query (from 2010 onwards). Chapters: 0:00 Excel Olympics Animation 0:08 Introduction to the sample data 1:23 Smaller Example 2:04 Example with double header rows 4:28 Fill Down 4:53 Merging Columns 5:33 Transpose command 5:56 Use First Row As Headers 6:28 UnPivot Other Columns 8:22 Conclusion 9:31 OutroFuncties: Excel.CurrentWorkbook()
