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. Department
names written inconsistently across every row.
Dates in 3 different formats. Missing patient
balances on multiple records. Payment status
incomplete across the billing sheet.
I cleaned all 3 sheets independently, merged
everything into one master clinical table and
calculated all missing patient balances
automatically.
Built a pivot view showing revenue breakdown
by department per visit type. Delivered an
input sheet with dropdown validation for
Department, Visit Type, Insurance Type and
Payment Status so new patient data is always
entered correctly.
Final summary dashboard shows total revenue,
total outstanding balance, busiest department,
most common diagnosis, total visits and paid
versus pending breakdown — two charts included,
all updating automatically with one refresh.
0
9
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 states.
The raw data had duplicate transactions,
Inconsistent entries throughout, missing revenue
on 14 rows and no connection between any of
the sheets.
I cleaned all 3 sheets independently, merged
everything into one master sales table, calculated
all missing revenue and profit figures automatically
and built a pivot view comparing performance
across all 4 states per product category.
Final delivery included an input sheet with
dropdown validation so new data is always
entered correctly, and a summary dashboard
with total revenue, total profit, top sales rep,
best performing state and two dynamic charts —
All updating automatically updated with one click.
0
25
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 one master sales table, and matched each sale with
correct product details, calculated all missing amounts
automatically using Quantity × Unit Price.
Built a Pivot View showing revenue comparison across
all 3 branches per product category. Delivered a
Summary Dashboard with key metrics and charts showing
the best-performing branch and the top-selling category.
Set up an input sheet with dropdown validation so the client
adds new monthly sales and clicks Refresh to update
everything automatically.
0
37
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 inconsistencies
department and location names, unified date formats,
handled all missing values and calculated correctly
Net Pay for every employee.
Merged both sheets using Employee ID as the common key.
Built an Input Sheet so the client adds new monthly payroll
data and clicks Refresh to update everything automatically.
Delivered a Summary Dashboard showing total monthly payroll,
highest earner, average salary, and the HR (http://employees.HR) Payroll System — Data Cleaning, Merge, Auto Refresh & Summary Dashboard
0
39
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 table,
pivot view for easy product comparison per month,
and unpivot view ready for charts and analysis.
0
51
Sales Data Cleaning — Retail Business
0
54