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.
76 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% 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
"I am an excel expert" ـــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــ