Find Jobs
Hire Freelancers

Excel - Script to merge duplicate rows with same ID (email address) but different column values

$30-250 USD

Inaendelea
Imechapishwa over 5 years ago

$30-250 USD

Kulipwa wakati wa kufikishwa
I have a data export that contains duplicate rows of data for the same user identified by email address. All of the other columns in the spreadsheet for each user can be different. Some will be NULL and others may have values. I need a VB script that will do the following: 1. Identify duplicate rows identified by the email address column 2. Consolidate each set of rows with the same email address: a. If all values in a column for each set of rows is NULL then value should remain NULL. b. If a column for each set of rows contains one value, include that value in the final/consolidated row. c. If a column for each set of rows has data in multiple rows, concatenate that data using semicolon delimiter for the final/consolidated row.
Kitambulisho cha mradi: 18201969

Kuhusu mradi

65 mapendekezo
Mradi wa mbali
Inatumika 5 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
Hi: I can create a script in VBA (macro) or Python to achieve this automation task. The script will merge duplicate rows based on Email id column. Columns with non-null values will be concatenated by semi-colon delimiter. It would be great if you could share the sample file. I would like to highlight that I take payment only after successful completion of the project. Looking forward to working with you.
$30 USD ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
65 wafanyakazi huru wana zabuni kwa wastani $100 USD kwa kazi hii
Picha ya Mtumiaji
Dear Employer, I perfectly understand what you require. Please share the excel sheet on which you need the macro to remove the duplicate records. I will do the job for you. Thanks and Regards, Ash
$155 USD ndani ya siku 3
5.0 (218 hakiki)
7.9
7.9
Picha ya Mtumiaji
I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid or playing games. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. I promise to deliver 100% Satisfaction.I have more than 5 year of experience in Data Processing, Excel, Visual Basic. Please ping me for more discussion.
$200 USD ndani ya siku 2
4.9 (403 hakiki)
8.1
8.1
Picha ya Mtumiaji
Hi I'd be happy to provide the macro for this task. Can deliver solution within a few hours . . ,
$110 USD ndani ya siku 0
4.9 (261 hakiki)
7.7
7.7
Picha ya Mtumiaji
Hello, i am serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of excel VBA projects without a single problem. Many of them deal with merging rows based on unique identifier. If you are interested in working with me, please share a sample file so i can see what exactly needs to be done. Thanks, Milan
$49 USD ndani ya siku 0
5.0 (580 hakiki)
7.2
7.2
Picha ya Mtumiaji
Hi, I am an Excel VBA expert with more than 15 years of experience in this field. Let me know and kindly provide sample Excel file containing data. Shall deliver the script within a couple of hours on confirmation. Regards, Arul
$80 USD ndani ya siku 0
5.0 (204 hakiki)
7.4
7.4
Picha ya Mtumiaji
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel, and VBA developer. I'm going to develop the required macro that will sort your records by the ID column (email address) and will scan one row at a time for duplicates. All values bonded with the same mail address will be concatenated in the corresponding columns. I'm among the most experienced, and skilled Excel, and VBA developers on this platform. I have completed 267 projects successfully in less than six years, and I feel confident to complete your project as well. You're welcome to visit my page on this platform (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I'm online from 8 am to 9 pm daily (including weekends), Athens time. I'm looking forward to working with you. Sincerely, Paris Pallas
$100 USD ndani ya siku 3
4.9 (278 hakiki)
7.7
7.7
Picha ya Mtumiaji
Hi there,I am Miljan,Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$190 USD ndani ya siku 7
4.9 (151 hakiki)
7.5
7.5
Picha ya Mtumiaji
Dear client I understand the scope of work involved in the project. I can build the macro for you. Please contact me. Roy
$120 USD ndani ya siku 1
4.9 (435 hakiki)
7.2
7.2
Picha ya Mtumiaji
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed more than 250+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
$100 USD ndani ya siku 3
4.9 (264 hakiki)
7.0
7.0
Picha ya Mtumiaji
Hi, I did similar projects in the past by using formulas and VBA. I am a financial expert and guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. I prepare proposals for investors (including pitch decks, business plans, due diligence, financial modules like feasibility studies, and financial projections with dynamic scenarios). I prepare dynamic & designed reports for pitch decks, business plans, due diligence, financial modules, feasibility studies, and financial projections with scenarios and charts. With these skills, I come up with creative and sophisticated financial & statistical modules in a simplified and logical manner.
$250 USD ndani ya siku 3
4.9 (92 hakiki)
7.2
7.2
Picha ya Mtumiaji
Hello, I understand your requirements and i can provide you a vb.net based tool to generate the required output file. Please let me know if you are interested. Thanks
$48 USD ndani ya siku 1
5.0 (168 hakiki)
7.1
7.1
Picha ya Mtumiaji
Hello, I can write the required VBA script within 2 days. You may release payment after testing the project. I have done similar Excel projects in the past. Thank you, Usman
$160 USD ndani ya siku 2
5.0 (89 hakiki)
7.0
7.0
Picha ya Mtumiaji
Hello, I am experienced vb/excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards
$111 USD ndani ya siku 3
5.0 (120 hakiki)
6.5
6.5
Picha ya Mtumiaji
Hello It looks as elementary task can be completed in couple of hours of pure working time. I have over 2 years of experience with Excel and VBA.
$35 USD ndani ya siku 1
4.9 (389 hakiki)
6.6
6.6
Picha ya Mtumiaji
Ok Sure
$155 USD ndani ya siku 2
5.0 (136 hakiki)
6.6
6.6
Picha ya Mtumiaji
Hello Sir, I can make Excel - Script to merge duplicate rows with same ID (email address) but different column values with 100% accuracy. I can start to work in your project immediately. Please contact me, So we can discuss more over chat.
$100 USD ndani ya siku 3
4.9 (92 hakiki)
6.3
6.3
Picha ya Mtumiaji
Hi, I am an expert in excel, VBA, MySQL and power bi. I can merge the duplicate rows bu in different columns. Please send me a sample file I will complete will send you. after checking it you can award me. Thanks
$50 USD ndani ya siku 3
4.8 (94 hakiki)
6.2
6.2
Picha ya Mtumiaji
Hello, I am Excel and VBA expert. I can do this project (Excel VBA macro) in one day. If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 50 projects. Jan
$100 USD ndani ya siku 1
5.0 (98 hakiki)
6.2
6.2
Picha ya Mtumiaji
Hello there, as an excel and vba expert, i can develop such a vba script to accomplish all your above mentioned tasks. Please contact me and let us talk more about your project. Thanks
$100 USD ndani ya siku 3
5.0 (83 hakiki)
5.8
5.8
Picha ya Mtumiaji
Hello, I am Luis and I would like to assist you with this project. Please contact me by chat in order to discuss further details! Luis Romero
$80 USD ndani ya siku 3
5.0 (150 hakiki)
5.8
5.8

Kuhusu mteja

Bedera ya CANADA
huntley, Canada
5.0
123
Njia ya malipo imethibitishwa
Mwanachama tangu Ago 24, 2005

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.