Convert Excel datable into several tables

€8-30 EUR

Concluído

Publicado

há quase 9 anos

€8-30 EUR

Pago na entrega

We have 1 table where Parents and Kid are on the same row, and we expect 2 tables: one defining the family (1 familiy per row), the 2nd defining a person (also 1 per row: a family with 3 members will give 3 rows in this table). We have a data table in Excel with 2400 rows and the following schema: adh_ID - NAME - FORNAME - INFOS - PARENTS - ADDRESS - TEL - EMAIL where NAME = Kid's name INFOS = Kid's infos PARENTS = Dad's name and forname / Mum's name and forname (yes, we know, it's bad :-) and we would like in final the following model: table = FAMILY fields = fam_ID (id based on the previous adh_ID: ADH02356 will produce FAM02356) table = PERSON fields = fam_ID - per_ID_x - NAME - FORNAME - INFOS - ADDRESS - TEL - EMAIL where per_ID_x = id based on the previous adh_ID: ADH02356 will produce PER02356A for the kid, and PER02356B for Dad, PER02356C for Mum (if they are presents) NAME - FORNAME = the one's of the kid, or the one's of the parents extracted from the PARENTS field INFOS = only for Kids ADDRESS - TEL - EMAIL = for kids or for parents, just copy all the same data Thanks in advance for your help

Data Processing

Excel

ID do Projeto: 7542082

Sobre o projeto

39 propostas

Projeto remoto

Ativo há 9 anos

Quer ganhar algum dinheiro?

Endereço de e-mail

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo

Seja pago pelo seu trabalho

Descreva sua proposta

É grátis para se inscrever e fazer ofertas em trabalhos

Concedido a:

@watersev

Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene

€14 EUR em 0 dia

5,0

(257 avaliações)

6,6

39 freelancers estão ofertando em média €28 EUR for esse trabalho

@FINGERRPRINT

Hi, Easy work, but need to do it carefully. I strongly beleive, I am the right person for this work and Completed many similar type of project with 100% accuracy. You could see my previous work and client feedback in the below url for hassle free service, https://www.freelancer.com/users/1195043.html Hope you would consider my bid and give an opportunity to work for you. Best Regards Venkatesh.D FINGERRPRINT

€105 EUR em 3 dias

4,9

(302 avaliações)

8,1

@zExcel

A proposal has not yet been provided

€48 EUR em 1 dia

4,9

(256 avaliações)

7,7

@TonmoyRoy111

Dear Sir, I have a sound knowledge in excel formulas and macros. I have previously carried out a number of projects in excel using macro and formulas. I ensure you of completing the task successfully within specified time. Kindly contact me for further details. Thanks and regards Tonmoy Roy

€30 EUR em 1 dia

4,9

(499 avaliações)

7,5

@zebracaro

I can do it for you quickly and exactly. . . .

€24 EUR em 1 dia

4,9

(123 avaliações)

7,1

@cugamelover

I'm a computer science professional with a PhD degree and extensive experience in Excel. Please see the reviews on my profile for ALL skills. It would be my pleasure to do your project. Please have a look at a large Excel project I did recently: https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/ One more Excel project I did: https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/

€27 EUR em 1 dia

4,8

(199 avaliações)

7,2

@Harun1986

A proposal has not yet been provided

€23 EUR em 1 dia

4,9

(171 avaliações)

6,5

@DeepSyaal

A proposal has not yet been provided

€30 EUR em 2 dias

4,9

(259 avaliações)

6,6

@diamond247

Hello Sir, We are a team (19 operator and 2 Quality checker)here from last 4 year giving all research service world wide with best quality output , I have gone through your project description, It is really a interesting job, and our operator are experienced enough in research skill so they easily can collect the data from several source, from a deep investigation, but its bit time consuming job not a copy paste. We would like to talk in details and give the total structure about how we ll do this job if you need. Waiting for your reply. Thanks Dg

€22 EUR em 1 dia

4,7

(179 avaliações)

6,9

@dragos1910d

A proposal has not yet been provided

€100 EUR em 2 dias

5,0

(86 avaliações)

5,8

@rajibchy903

Dear Hiring Manager, I am highly interested to work with this position. I am very familiar with Web Research, Email Marketing, Email List Building, Zoho CRM, SalesForce, Xero, Word Press, eBay, Amazon, Facebook, Twitter, LinkedIn, Lead Generation, Data Gathering, MS Word, MS Excel, Adobe Photoshop CS5, Adobe Illustrator CS5, Google Docs and Drop box. I am available to work during 5am-10pm at Pacific Standard Time Zone. As regards my fitness to the job, complete profile enclosed herewith for your kind perusal and sympathetic consideration. I am available to chat and talk by Skype, GTalk and Yahoo Messenger. Your regards Rajib Chowdhury

€20 EUR em 1 dia

5,0

(45 avaliações)

6,0

@kevivu

Having more than 11 years of experience in data analysis and reporting. Extensively used MS EXCEL AND IT'S FORMULAE. Hence I can complete the task very quickly without compromising the quality.

€18 EUR em 0 dia

4,9

(85 avaliações)

6,2

@ethicalboy

Hello, this task required a macro to transform the data in your desired format and tables. It would be more great if you can provide your file too, also about me: I am m.s of systems engineering and b.s of industrial engineering, and excel(dashboard, pivot tables, charts, conditions, conditional formatting, statistical, financial, mathematical, string, time, date,..functions), creating pretty charts and vba expert. I have done similar projects and I am confident about my profession, I also accept revisions and removing errors and minor changes in future for free, whenever you are ready lets go. I have good command of English that I think can be useful for this project. I have also a team that help me to fasten doing this project. I may write a macro to handle task.

€48 EUR em 4 dias

4,8

(73 avaliações)

5,4

@arman0464

!!Hello Sir/Madam, Ready to start. I have completed 300 project and I read your description carefully and understand all your requirements. I have 6 years experience in this field. I have good team SEO, Web Design, Photo Shop, Image Editing, Data Entry, Excel, Web Scraping, Web Search, PDF to excel, PDF to Word, Image to text I’m astute, creative, and pay attention to detail. Feel free to contact me before you decide. Thank you for your consideration, Shareef

€30 EUR em 1 dia

4,6

(82 avaliações)

5,3

@dank111

Hi, My name is Dan. I am an expert in excel and all advanced functionalities. I can transform the existing table into two tables as desired. Please message me and share the data so that we can proceed further. Thanks ! Regards Dan

€34 EUR em 2 dias

4,9

(10 avaliações)

4,3

@jnekam

Hi dear Hiring manager! I have VBA codes ready for your project. I would be glad to work with you. Please contact me to discus further detail of the project. Thanks

€23 EUR em 1 dia

4,6

(12 avaliações)

4,0

@jperusan

I'll do an application for that job so there sure will be no errors. I can also give you that application so you dont need to hire anyone anymore for that kind of job because you will be capable to do it by yourself in couple of seconds.

€30 EUR em 1 dia

5,0

(5 avaliações)

2,7

@Inave

Hello, My name is Ivan my experience with MS Excel is more than 10 years. I have created thousands different projects based on Excel. I will complete your required task and will provide further assistance if needed. If you are interested in my offer please contact me firs via PM to clarify the details and possibly prepare sample for verification

€14 EUR em 3 dias

5,0

(1 avaliação)

1,6

@vivekb67

I am pleased to take this project. If you can provide a sample set of data to be processed and the required format, then it will be easier to process entire set. As per the description of project, there is only single field in the table "FAMILY". [ table = FAMILY fields = fam_ID (id based on the previous adh_ID: ADH02356 will produce FAM02356) ] Is it sufficient OR some other fields will have to be considered in this table. Looking forward for feedback and to work on this project.

€15 EUR em 2 dias

5,0

(1 avaliação)

1,1

@FedjaH

Hello Sir I'm using Excel everyday and this is no problem for me I can do this ASAP Looking forward to your message Have a nice day

€23 EUR em 1 dia

0,0

(0 avaliações)

0,0

@jonaboy

I am an experienced professional accountant and auditor, article writer, researcher, resume writer and academic writer. I am also about finishing my MBA course in the university. I read your project description and perfectly understand what you need. I am hardworking and committed, so you can expect a high quality work from me. Thank you for reading my bid. Jonaboy.

€34 EUR em 2 dias