IMPORTANT: Only respond if you are Excel expert.
See demo attached. This is just an extract from the file to be used.
Task 1: Remove Duplicate records. A duplicate is where Registered Service Provider AND Head Office AND Telephone values are the same. End result is to have a single record for each set of duplicates.
Task 2: Split address values in a single cell split into 5 cells of Address line 1, Address line 2, City, State, Postcode.
Task 3: Groups Tan
Remove Duplicates. A duplicate is where the Registered Service Provider AND the Group values are the same.
Goal is to have a single record for each Registered Service Provider and Group combination.
When bidding send a note saying "I am an excel expert" so I know you read the spec.
77 freelanceria on tarjonnut keskimäärin 93 $ tähän työhön
i am an excel expert, ok sure, i understand, and in next few hours i will get this done with 100% accuracy you bet, please share me full file, the sample is all clear, thx
dear sir I am an excel expert having hands on expertise in data validation I will do your project as per your requirement. best regards. humayoon