Zarex Rylo
Automating messy data cleaning with Excel & Power Query.
New to Contra
Zarex is building their profile!
MedCore Clinical Services — 3 Sheet Merge, Billing Automation & Department Dashboard
A US medical clinic came to me with patient
visits, doctor records and billing data sitting
in 3 completely separate sheets with no
connection between them.
Duplicate visit records throughout....
TechMart Electronics — 3 Sheet Merge, Pivot & Automated Dashboard
A US electronics retail store came to me with
3 completely disconnected sheets — sales
transactions, product details, and customer
records — and no way to see how their business
was actually performing across 4...
The client runs a retail business with 3 branches in Lagos,
Abuja and Kano. Sales data was scattered across separate
sheets with inconsistent entries, missing amounts, and
no way to see overall business performance.
Cleaned all branch data independently, merged everything
into...
HR Payroll System — Data Cleaning, Merge, Auto Refresh & Summary Dashboard
Client had two separate sheets — employee information
and monthly payroll records that needed to be cleaned
and combined into one master table.
Cleaned both sheets independently, fixed the...
Monthly Sales Data — Cleaning, Pivot & Unpivot Transformation
Cleaned messy monthly sales data for a retail business.
Fixed inconsistent month, region and product names,
removed duplicates and handled missing values.
Delivered four views in one workbook — full clean...