Zarex Rylo
Automating messy data cleaning with Excel & Power Query.
New to Contra
Zarex is ready for their next project!
ShopZone UK — 5 Sheet Ecommerce Merge, Returns Analysis & Automated Dashboard
A UK online store came to me with orders, returns,
customer details, product inventory and delivery
partner data all sitting in 5 completely separate
sheets with no connection between them.
Duplicate...
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...