I will clean messy excel data, remove duplicates, text to columns

Pakistan

I speak English, Urdu

Data Entry expert Excel and google sheets and VA

Hi, I'm Sania Niaz - Your Professional Data Entry & Excel Expert 📊 I help busy business owners, and e-commerce sellers save time by managing th...
About this Gig

Do you have messy data like in my gallery image? I will clean it!


LEFT = Messy Data (Your file)

- Names: usman ghani / ZAINAB

- Dept: SALES / sales / hr / it

- Date: N/A, 24-02-20, 12/11/2024

- Status: fail / FAIL / Pass / N/A


RIGHT = My Clean Delivery

- Clean Name: Usman Ghani, Zainab (Proper Case)

- Clean Dept: SALES, MARKETING, FINANCE

- Clean Product: Mobile, Laptop, UNKNOWN

- Clean Status: Fail / Pass (Same Format)

- Clean Bonus%: 0% to 20% Fixed


WHAT I FIX:

1. Names to Proper Case

2. Dept to Uppercase

3. Product, Qty, Price Separation

4. Date Format Fix (N/A cleaned)

5. Status (fail/Pass to same style)

6. Duplicates & Extra Spaces (TRIM)


I already cleaned 25+ rows in this image. I will do same for you.


Packages: $15=250 Rows (1 Day), $30=500 Rows, $50=1000 Rows

FREE Preview of 5 Rows - Just Contact Me!


Sania - Data Cleaning Expert


My Portfolio