Power Query practice: Transposing, Filling & Structural Fixes
Chapter 16 · 5 questions · included in full access
Question 1 · medium
Skip the title rows
Solve it in your browserStockReport has two title lines above the real header. Remove Top Rows (2), then Use First Row as Headers.
Question 2 · easy
Fill down the warehouse
Solve it in your browserEach warehouse name is typed only on its first row. Select Warehouse ▸ Transform ▸ Fill ▸ Down.
Question 3 · hard
The whole report clean-up
Solve it in your browserFrom raw StockReport: remove the 2 title rows, use the first row as headers, fill down Warehouse, and set Qty to Whole Number.
Question 4 · medium
Transpose table orientation
Solve it in your browserTranspose the first 3 rows of StockReport: skip 2 rows, take top 3 rows with
Table.FirstN, then transpose usingTable.Transpose.Question 5 · medium
Fill up sparse metadata
Solve it in your browserSkip 2 rows, promote headers with
Table.PromoteHeaders, then fill up the Warehouse column usingTable.FillUp.
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing