Find Jobs
Hire Freelancers

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

$30-250 USD

In corso
Pubblicato più di 5 anni fa

$30-250 USD

Pagato al completamento
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.
Rif. progetto: 18201969

Info sul progetto

65 proposte
Progetto a distanza
Attivo 5 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
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 in 1 giorno
0,0 (0 valutazioni)
0,0
0,0
65 freelance hanno fatto un'offerta media di $100 USD
Avatar dell'utente
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 in 3 giorni
5,0 (218 valutazioni)
7,9
7,9
Avatar dell'utente
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 in 2 giorni
4,9 (403 valutazioni)
8,1
8,1
Avatar dell'utente
Hi I'd be happy to provide the macro for this task. Can deliver solution within a few hours . . ,
$110 USD in 0 giorno
4,9 (261 valutazioni)
7,7
7,7
Avatar dell'utente
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 in 0 giorno
5,0 (580 valutazioni)
7,2
7,2
Avatar dell'utente
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 in 0 giorno
5,0 (204 valutazioni)
7,4
7,4
Avatar dell'utente
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 in 3 giorni
4,9 (278 valutazioni)
7,7
7,7
Avatar dell'utente
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 in 7 giorni
4,9 (151 valutazioni)
7,5
7,5
Avatar dell'utente
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 in 1 giorno
4,9 (435 valutazioni)
7,2
7,2
Avatar dell'utente
"""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 in 3 giorni
4,9 (264 valutazioni)
7,0
7,0
Avatar dell'utente
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 in 3 giorni
4,9 (92 valutazioni)
7,2
7,2
Avatar dell'utente
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 in 1 giorno
5,0 (168 valutazioni)
7,1
7,1
Avatar dell'utente
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 in 2 giorni
5,0 (89 valutazioni)
7,0
7,0
Avatar dell'utente
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 in 3 giorni
5,0 (120 valutazioni)
6,5
6,5
Avatar dell'utente
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 in 1 giorno
4,9 (389 valutazioni)
6,6
6,6
Avatar dell'utente
Ok Sure
$155 USD in 2 giorni
5,0 (136 valutazioni)
6,6
6,6
Avatar dell'utente
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 in 3 giorni
4,9 (92 valutazioni)
6,3
6,3
Avatar dell'utente
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 in 3 giorni
4,8 (94 valutazioni)
6,2
6,2
Avatar dell'utente
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 in 1 giorno
5,0 (98 valutazioni)
6,2
6,2
Avatar dell'utente
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 in 3 giorni
5,0 (83 valutazioni)
5,8
5,8
Avatar dell'utente
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 in 3 giorni
5,0 (150 valutazioni)
5,8
5,8

Info sul cliente

Bandiera: CANADA
huntley, Canada
5,0
123
Metodo di pagamento verificato
Membro dal ago 24, 2005

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.