Convert Excel datable into several tables

€8-30 EUR

Abgeschlossen

Veröffentlicht

vor fast 9 Jahren

€8-30 EUR

Bezahlt bei Lieferung

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

Projekt-ID: 7542082

Über das Projekt

39 Vorschläge

Remote Projekt

Aktiv vor 9 Jahren

Möchten Sie etwas Geld verdienen?

E-Mail-Adresse

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest

Für Ihre Arbeit bezahlt werden

Skizzieren Sie Ihren Vorschlag

Sie können sich kostenlos anmelden und auf Aufträge bieten

Vergeben an:

@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 in 0 Tag

5,0

(257 Bewertungen)

6,6

39 Freelancer bieten im Durchschnitt €28 EUR für diesen Auftrag

@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 in 3 Tagen

4,9

(302 Bewertungen)

8,1

@zExcel

A proposal has not yet been provided

€48 EUR in 1 Tag

4,9

(256 Bewertungen)

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 in 1 Tag

4,9

(499 Bewertungen)

7,5

@zebracaro

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

€24 EUR in 1 Tag

4,9

(123 Bewertungen)

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 in 1 Tag

4,8

(199 Bewertungen)

7,2

@Harun1986

A proposal has not yet been provided

€23 EUR in 1 Tag

4,9

(171 Bewertungen)

6,5

@DeepSyaal

A proposal has not yet been provided

€30 EUR in 2 Tagen

4,9

(259 Bewertungen)

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 in 1 Tag

4,7

(179 Bewertungen)

6,9

@dragos1910d

A proposal has not yet been provided

€100 EUR in 2 Tagen

5,0

(86 Bewertungen)

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 in 1 Tag

5,0

(45 Bewertungen)

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 in 0 Tag

4,9

(85 Bewertungen)

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 in 4 Tagen

4,8

(73 Bewertungen)

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 in 1 Tag

4,6

(82 Bewertungen)

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 in 2 Tagen

4,9

(10 Bewertungen)

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 in 1 Tag

4,6

(12 Bewertungen)

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 in 1 Tag

5,0

(5 Bewertungen)

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 in 3 Tagen

5,0

(1 Bewertung)

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 in 2 Tagen

5,0

(1 Bewertung)

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 in 1 Tag

0,0

(0 Bewertungen)

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 in 2 Tagen