I have had a few spreadsheets with data in it merged together and now all i have to do is delete any multiple entries without losing any data. It needs to be a manual job in order to not delete rows in the document due to automatic cleanups using excel features unless you are an expert in excel. I have attached the data file and the first tab is the data that needs to be cleaned up and the second shows a series of the same business name across 2 locations and how i need to consolidate the information. I have completed up to the end of the letter A in the spreadsheet shaded in grey to show you what the finished product will look like. On the second tab called sample explains how the finished outcome will look like for one business name listing. I have explained how this is consolidate further down. If anyone thinks they can do a good job of a simple task and if you have any tricks to fill in any of the other cells for broken down address fields then please take on this task.
Please refer to sample tab. You will see the same business across 2 locations. one location is in Morley the other is in Caversham. Basically i need to keep one of each location and merge as much of each location my pasting other cells together so i don't lose the email addresses or other cell information. You will see the detailed address fields didn't have the email address so i have copied and pasted the email addresses into the most detailed address line for each and deleted all other rows. You will see how i would like the end result spaced down a little further for sample 2 and then if you have sound knowledge of excel or can do it manually then filling in the extra address fields based on the full address field column. if some other rows have the address already you will need to paste those in before deleting the rows. I need each location to have as much information shared to make one row for each location as detailed as possible.
Please only accept this task if you are 100% confident you understand what is required as i have had too many jobs on here where the result hasn't been quite right. before I accept a freelancer I would like to see a very quick sample of my data merged as specific. I have made a 3rd tab called TEST for you to show me how you would do this. You will need to keep the gym data for each suburb so for example I prefer the gyms to be called by their locations, so Renouf Personal Training Duncraig instead of the one in Duncraig listed as Renouf Personal Training or Renouf Personal Training Centre. I hope that makes sense. These are all the same gym but have just been extracted differently, so you will need to get the best data from the best cells to make 1 really good detailed listing. I will award the job based on an accurate understanding of the job. Also I require this in 24-48 hours max. Thanks everyone.
hiee.."SAMPLE DONE"...I can complete this task in 24-48 hours...please contact me or send me a msg for a test file (already done)...Regards, Raj !!~@
10 freelancers estão ofertando em média $49 para esse trabalho
Hi. I have a lot of experience in Excel. I am an expert. I will satisfy you. I will provide quick time and exactness. And I will provide full time for your project. Best regards.