Power QueryExercises

Fill batch labels up a production sheet (brewery)

The batch number is printed on the last line of each batch block. Fill it upward so every line has its batch.

Level
beginner
Time
~6 min
Task
Build the query
Access
Pro
Checking your access…

About this exercise

What you'll practise

Use Fill Up when labels sit at the end of their block.

The scenario, sample data, step list, hints and solution open with Pro. Grading checks your query against hidden data as well as the visible sample, so a query that only fits the sample doesn't pass.

Input

  • Sheet (table)
    • Item: text
    • Qty: number
    • Batch: text (nullable)

Expected output columns

Item (text), Qty (number), Batch (text)