Power QueryExercises

Staff roster

An HR export from a fictional logistics firm, with names typed inconsistently.

What's messy

Columns

ColumnTypeNote
EmpIDtext
FirstNametextMessy
LastNametextMessy
Departmenttext
Citytext
Salarywhole numberSensitive
StartDatedate (yyyy-mm-dd)
ManagertextBlank for top level
EmailtextSensitive

Try these

Preview (first 8 rows)

EmpIDFirstNameLastNameDepartmentCitySalaryStartDateManagerEmail
E100 junDUARTE SalesRiverton730002021-09-01nulljun.duarte@harbourfreight.example
E101 baoBrandtFinanceAshford550002020-10-19E100bao.brandt@harbourfreight.example
E102 lenaFOFANA SupportGranby510002017-10-04E100lena.fofana@harbourfreight.example
E103 esiEklundSalesLakeport380002019-01-23E100esi.eklund@harbourfreight.example
E104 baoItoFinanceGranby910002019-11-12E101bao.ito@harbourfreight.example
E105GoranNovakOperationsLakeport660002022-02-02E103goran.novak@harbourfreight.example
E106HanaSILVA FinanceAshford820002018-05-09nullhana.silva@harbourfreight.example
E107OmarCASTILLO OperationsGranby830002023-04-20E103omar.castillo@harbourfreight.example

All data is fictional. CSV cells that could be read as spreadsheet formulas are prefixed with an apostrophe.