Concluído

URGENT SIMPLE JOB: Clean up multiple entries in spreadsheet

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.

SAMPLE

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.

Habilidades: Processamento de Dados, Excel

Veja mais: where to get data entry job, where is freelancer based in, where get data entry job, where do i look for job as freelancer, what to do in data entry jobs, what makes a good freelancer, what job to get, what job for an excel expert, what is manual data entry, what is data entry test, what is a data entry test like, what is a data entry test, what if the freelancer end the job, tricks on excel, the best job to have, thanks letter sample, test excel expert, spreadsheets jobs, sound jobs, second job, sample of data entry jobs, sample job listing, right now just like freelancer, personal training jobs, order entry jobs

Acerca do Empregador:
( 19 comentários ) Balcatta, Australia

ID do Projeto: #6095271

Concedido a:

RajHeartbeat

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 !!~@

$30 AUD em 3 dias
(56 Comentários)
5.9

10 freelancers estão ofertando em média $49 para esse trabalho

Innovative116

Hi. I have done sample spreadsheet. Kindly ping me so I can send you sample spreadsheet right away. Please check my feedbacks for my expertise in similar excel projects done. The task required is all manual as merging Mais

$95 AUD in 2 dias
(152 Comentários)
7.4
livegoodlife

Hi i have deleted the duplicates please send me a message to attach the file to review by you. waiting to send you the file

$157 AUD in 3 dias
(40 Comentários)
5.5
vickkey7

Hi, I am ready to start this project,.. I can help you within your time frame, Give me chance to start this.. thanks

$51 AUD in 2 dias
(12 Comentários)
4.1
AISWARYAVAKA

I am a graduate student and i am very good at working with EXCEL. I also work as an office assistant. I hope i can help you very well.

$30 AUD em 1 dia
(0 Comentários)
0.0
gmounir

Hi, my name is Giovanni and I do Excel worksheets as well as copy typing. I understand that you would like to remove duplicate entries from your excel worksheet and merge them into one row if possible and I will be ver Mais

$30 AUD em 1 dia
(0 Comentários)
0.0
dipanchalft

I have good excel knowledge and working regularly on desktop. Microsoft excel is used by me very effectively.

$15 AUD in 2 dias
(0 Comentários)
0.0
junaidgondal1019

Given project is inline with my skills. I'm confident that i can deliver the required output in the mentioned time frame. Moreover the bidder is new in freelancing but not in work & his experties. I would apprecia Mais

$27 AUD em 1 dia
(0 Comentários)
0.0
pwahi2030

A proposal has not yet been provided

$25 AUD em 1 dia
(0 Comentários)
0.0
undersky1230

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.

$66 AUD em 1 dia
(0 Comentários)
0.0
mstr850

Hi, I feel confident to fulfill this job as i have necessary skills and i have the ability to meet the dead line in timely manner. Thanks

$25 AUD in 2 dias
(0 Comentários)
0.0