Power QueryExercises

Rename and reorder columns for a finance report (kite shop)

Give columns business-friendly names and put them in the order finance expects.

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

About this exercise

What you'll practise

Rename columns and set an explicit column order without changing any values.

Northwind Kites sells kites and accessories through three regional stores. Orders are exported from the till system every week.

Steps

  1. Keep OrderDate, OrderID, Customer and UnitPrice.
  2. Rename them to Order Date, Order Number, Customer Name and Unit Price.
  3. Order the columns: Order Number, Order Date, Customer Name, Unit Price.

Your result must

  • Exactly four columns in the stated order
  • Values are unchanged
  • Still works when the export gains a column

Input

  • Orders (table)
    • OrderID: text
    • Customer: text
    • Region: text
    • Product: text
    • Qty: number
    • UnitPrice: number
    • OrderDate: text
    • Status: text

Expected output columns

Order Number (text), Order Date (text), Customer Name (text), Unit Price (number)

First 3 of 10 expected rows
Order NumberOrder DateCustomer NameUnit Price
00012026-03-03Priya Grieve16.53
00022026-04-21Rosa Lindqvist58.72
00032026-06-21Sven Zielinski14.18