Project Title: Excel Sheet Data Cleaning
I have an Excel file containing a lot of anchor texts. The anchor words are separated in columns by their categories. Each column has its category name.
I want these links to be cleansed and separated in different sheets by their categories which means you have to create sheets by category names.
Then you will have to convert the anchor text to simple text and then to its URL.
Column ‘A’ should have anchor text, ‘B’ should have simple text and ‘C’ should have the URL of the Text.
I need a quick turnaround on this and will move into other files after this, doing the exact same thing.
Within how many days can you complete this job? Please advise.
For similar work requirements feel free to email us on email@example.com.