Power QueryExercises

Skip the title rows in a report export (consultancy)

The export starts with a report title and a blank line. Skip them, then promote the real headers.

Level
beginner
Time
~7 min
Task
Build the query
Access
Free — no account needed
Loading the practice workspace…

About this exercise

What you'll practise

Remove top rows before promoting headers, and understand why the order of those steps matters.

Brightline Advisory (fictional) reimburses consultants' expenses. Finance exports claims monthly from the expense tool.

Steps

  1. The first two lines are a report title and a blank line. Remove them.
  2. Use the next row as headers.
  3. Set Amount to a decimal number (en-US). Leave the other columns as text.

Your result must

  • Columns: ClaimID, Employee, Category, Amount, Currency, ClaimDate, Approved
  • No title or blank rows in the data
  • Amount is a number

Input

  • ClaimsReport (file)
    • Text file; first line: Expense claims report,,,,,,
    • Every field is text until you set types

Expected output columns

ClaimID (text), Employee (text), Category (text), Amount (number), Currency (text), ClaimDate (text), Approved (text)

First 3 of 10 expected rows
ClaimIDEmployeeCategoryAmountCurrencyClaimDateApproved
C-0001Goran BrandtTraining291.59USD2026-05-05Yes
C-0002Dmitri YilmazSoftware141.6USD2026-03-12No
C-0003Goran BrandtMeals364.66USD2026-05-09No