Blog

05
Apr

Clean, Unify & Organize Excel File

Post By admin

Project Title: Clean, Unify & Organize Excel File

Project Description:
I have an excel file that I need to clean its data and make it unified and organized.

The file is around 80 column and 9000 row but the actual data should be in around 2700 row after it get organized as too many managed cells.

The Thing I want to achieve are:
1- Make each data set in 1 row, by removing the merged cells and combine the data in one cell.
2- Unify the numbers format
3- Unify and merge duplicated column data like City, country
4- Remove any duplicate data, the unique info here is the requested service.

The purpose is to merge these data into Zoho CRM

For similar work requirements feel free to email us on info@datacleaningservices.com.

  • Facebook
  • Twitter
  • Google Plus
  • Linkedin

Add a comment