Merge different tables/sheets into one

$45-60 USD

Selesai

Dibuat

hampir 4 tahun yang lalu

$45-60 USD

Dibayar ketika dikirim

*Please postulate yourself if you can complete this job within the following hours* I have the following data structure - Vehicles - - Brake Calipers - - - Piston Only - - - Repair kits - - - - Components The total amount of rows is probably 150K. The problem is that some information is spread on different sheets. I need someone who merges everything into a single dataset/sheet, with one row per each component if necessary; which could make this dataset as large as 1 million rows. The second part is much easier. Is simply assigning a unique ID number to each vehicle, brake caliper, piston only, repair kit and component. For a total of 5 additional columns containing these unique IDs. Contact me to deliver the datasheets. I can't attach them publicly.

ID Proyek: 26200289

Tentang proyek

87 proposal

Proyek remot

Aktif 4 tahun yang lalu

Ingin menghasilkan uang?

Alamat email

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda

Dapatkan bayaran atas pekerjaan Anda

Uraikan proposal Anda

Gratis mendaftar dan menawar pekerjaan

Diberikan kepada:

@rashedkhanrubel

Hi, I will organize dataset as per your requirement with good and professional quality without any error. Need to see the file and discuss more before start. I have completed more then 180 project within 1 Year with 5 star review. You are gentle requested to see excel project sample in my portfolio here: https://www.freelancer.com/u/rashedkhanrubel. I will deliver the project within timeline with better quality. If you want to award me the project I'd be very happy to discuss deeply about your requirement and get started for you as soon as possible. Thanks! Rashed

$45 USD dalam 1 hari

5,0

(402 ulasan)

7,6

87 freelancer menawar dengan rata-rata $53 USD untuk pekerjaan ini

@datakillers

Hi, I am an Excel Expert with Professional experience working with Excel. I have more than 10 year experience with excel. Complete a lot of jobs on Freelancer with highly satisfaction of client. I believe I can do a great work for you and ensure your quality.

$49 USD dalam 1 hari

4,9

(640 ulasan)

8,3

@P0L

Hello, I am an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$60 USD dalam 1 hari

5,0

(493 ulasan)

8,0

@akritisood94

Hi, With over 5 years of experience in Excel. I’ve worked with a variety of clients in Visual Basic and Excel VBA, etc. I’ve gone through your complete project description. I am interested in this project as it is exactly within the scope of my skill. My main skills are as follows: Visual Basic, Excel VBA, Excel Macro Thank you for your attention. Regards

$53 USD dalam 1 hari

4,9

(254 ulasan)

6,9

@amirn2011

Hello Sir, I am ready for your Merge different tables/sheets into one project. Please share me the sheet. Check my reviews to get an idea about my work. I'm online at the moment, feel free to initiate a chat; we can discuss further regarding your project. Thanking You. Regards Amir

$50 USD dalam 2 hari

4,9

(175 ulasan)

6,9

@kevivu

Completed numerous similar projects in the past and always impressed the clients with my excellent solutions. Expert in MS Office, Access/Excel/Word/Outlook, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Having more than 15 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Web research, etc., Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers.

$45 USD dalam 1 hari

4,9

(91 ulasan)

6,3

@Ayo25

I am a data entry specialist with advanced knowledge of Ms Excel, Google sheets and other statistical tools. I am very thorough with my work while speed and precision is my watchword. You can look at my track record on my profile. Looking forward to working with you. Thanks I am a creative writer with a

$60 USD dalam 3 hari

5,0

(17 ulasan)

6,2

@ravinderkumar248

Hi there, I can Merge different tables/sheets into one through vba macro. I have years of experience in Excel VBA, creating complex automation tools, formulas, databases, queries, and macros. Please contact me to discuss more. Thank you. Ravinder

$50 USD dalam 1 hari

4,9

(141 ulasan)

6,0

@swarnali2017

Dear Employer, I have read your project description very carefully. I know python programming that can find marge multiple table based on attributes and we can easily create new column value using product dictionary. I can start this project now and available online more than 16 hours everyday. Looking forward to hearing from you! Thanks in advance.

$45 USD dalam 3 hari

5,0

(39 ulasan)

5,7

@vsprybhanu

Hi, I can develop an excel vba program consolidate data from multiple sheets into one as per your requirements. I am experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to discuss your project in more details. Thanks, Virendra

$60 USD dalam 3 hari

4,8

(137 ulasan)

6,1

@Logo199

Hi there? Yes i can do this task ASAP. I am professional data entry operator who can do this task accurately thanks a lot Md Mohiul Islam

$55 USD dalam 1 hari

4,9

(87 ulasan)

5,9

@Ruchiagarwall

Hello sir, I have read complete details of project with title. Please share the excelsheets to merge all in one sheet and let me create the unique ID's for all rows or 5 columns. I will wait that you will ping me if you like my profiles. Ping me over chat for more. Thanks Ruchi

$45 USD dalam 1 hari

5,0

(70 ulasan)

5,5

@designer504

My expertise in this field What we Expertise in: PowerPoint, EBOOKS, LOGO, Prezi, Editable and Fillable PDF, 2D, EXPLAINER VIDEOS, ANIMATION, Indesign,Quark, Infographics, Illustrations, Brochures, Flyers, Posters, Business Cards, Corporate Identity, Tshirt Designing, Social Media Banners And Anything Related To Graphics Designing. Why choose us? O We understand your requirements precisely to deliver Creative designs O 100% client satisfaction guaranteed. O Provide help even after the project has been marked as Closed. O Work 6 days a week and available online on CHAT 24x7 for any queries

$60 USD dalam 1 hari

5,0

(13 ulasan)

4,9

@Ahmed818

Hello, Thanks for your invitation i have good experience in excel programming , see my profile i will write simple excel vba code to merge the excel files waiting your answer Thank you

$45 USD dalam 1 hari

4,9

(78 ulasan)

4,9

@SamirBanna

I am very interested in applying for your job since it seems to fit very will with my experience and skills. Regards SamirBanna

$60 USD dalam 2 hari

5,0

(15 ulasan)

4,5

@Jatin77777

Hello, I have gone through with contents and understand the requirements. I am interested to do this work and break your huddle. Please allow me to do this job. I am available to support you 24*7 just ping me once. I have a good knowledge of Excel, Advance Excel functions and VBA. I know Sumifs, Countifs, Averageifs, Index, Match, Vlookup, Hlookup, Sorting, Pivot table, Slicers, Developer functions & Conditional formatting, etc. Please check my portfolio to know more Thanks, Jitender Kumar

$53 USD dalam 1 hari

5,0

(24 ulasan)

4,7

@ammar3215

I am expert in excel , 6+ years of practical expertise, I can complete this task for you , please share details of the task & 100% quality of work is assured

$60 USD dalam 1 hari

5,0

(7 ulasan)

4,6

@nurnga1218

Hi, I think I can do that. I can do that with regular formulas or with macro function. The potential problem is the large of your file. But it's okay, I want to try it if you would like to send me that file. and I hope you will. I'm waiting you on chat. Thanks

$45 USD dalam 2 hari

5,0

(47 ulasan)

4,7

@babooshani49

Hi there, I have read and understood your project requirements. I will be able to work with you. Please leave a message so that we can discuss more over the chat. Thanks

$53 USD dalam 7 hari

5,0

(5 ulasan)

4,4

@mayureshmaradkar

I have done this work before as well and I have python code ready for such work..I can give the results to you within an hour that to at the least bid price..lower than 45$

$45 USD dalam 1 hari

5,0

(7 ulasan)

3,8

@ZhangDa

Interesting project. Could I get the data and check the format? I may only need tens lines sample data. I then create a code to do that. Like what you said, the big worksheet may reach 1 million? But I remember the biggest size of one Excel worksheet is 1 million. If there are too many lines (more than 1 million), we may need put them into 2 worksheets. Let's talk. Thank you.

$50 USD dalam 1 hari