Project Title: Clean, Unify & Organize Excel File
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 email@example.com.