Power QueryExercises

Remove salary and email before sharing a roster (logistics)

Share a staff list with managers without salary or email columns.

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

Remove named columns while keeping every other column, including ones added later.

Harbour Freight is a fictional logistics firm. HR exports its roster from the payroll system before each review cycle.

Steps

  1. Remove the Salary and Email columns.
  2. Keep all other columns in their original order.

Your result must

  • No Salary or Email column
  • All other columns kept, in source order
  • Every employee row kept

Input

  • Roster (table)
    • EmpID: text
    • FirstName: text
    • LastName: text
    • Department: text
    • City: text
    • Salary: number
    • StartDate: text
    • Manager: text (nullable)
    • Email: text

Expected output columns

EmpID (text), FirstName (text), LastName (text), Department (text), City (text), StartDate (text), Manager (text (some rows null))

First 3 of 8 expected rows
EmpIDFirstNameLastNameDepartmentCityStartDateManager
E100GoranOkaforOperationsWestmere2018-05-16null
E101NiaLindqvistFinanceRiverton2019-05-12E100
E102OmarUddinOperationsMillbrook2017-12-15null