Power QueryExercises

Make a mixed number/text code column all text (garden centre)

Product codes arrive as a mix of numbers (1001) and text (A-17, 0042). Make every code text.

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

About this exercise

What you'll practise

Convert a column that mixes value types to one type without losing information.

Greenway Garden Centre (fictional) merged two catalogues: the old one used numeric codes, the new one text codes.

Steps

  1. Code holds numbers for older products and text for newer ones (some with leading zeros).
  2. Make Code text in every row: numbers become their digits (1001 → "1001"), and text codes stay exactly as they are ("0042" keeps its zeros).
  3. Keep both columns, Code and Product.

Your result must

  • Every Code is text
  • "0042" keeps its zeros
  • No errors

Input

  • Catalogue (table)
    • Code: number or text
    • Product: text

Expected output columns

Code (text), Product (text)

First 3 of 8 expected rows
CodeProduct
1001Gloves 3
A-88Seed Tray 1
0081Hose 7