Find Jobs
Hire Freelancers

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

$30-250 USD

En curso
Publicado hace más de 5 años

$30-250 USD

Pagado a la entrega
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.
ID del proyecto: 18201969

Información sobre el proyecto

65 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
65 freelancers están ofertando un promedio de $100 USD por este trabajo
Avatar del usuario
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 en 3 días
5,0 (218 comentarios)
7,9
7,9
Avatar del usuario
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 en 2 días
4,9 (403 comentarios)
8,1
8,1
Avatar del usuario
Hi I'd be happy to provide the macro for this task. Can deliver solution within a few hours . . ,
$110 USD en 0 día
4,9 (261 comentarios)
7,7
7,7
Avatar del usuario
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 en 0 día
5,0 (580 comentarios)
7,2
7,2
Avatar del usuario
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 en 0 día
5,0 (204 comentarios)
7,4
7,4
Avatar del usuario
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 en 3 días
4,9 (278 comentarios)
7,7
7,7
Avatar del usuario
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 en 7 días
4,9 (151 comentarios)
7,5
7,5
Avatar del usuario
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 en 1 día
4,9 (435 comentarios)
7,2
7,2
Avatar del usuario
"""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 en 3 días
4,9 (264 comentarios)
7,0
7,0
Avatar del usuario
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 en 3 días
4,9 (92 comentarios)
7,2
7,2
Avatar del usuario
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 en 1 día
5,0 (168 comentarios)
7,1
7,1
Avatar del usuario
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 en 2 días
5,0 (89 comentarios)
7,0
7,0
Avatar del usuario
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 en 3 días
5,0 (120 comentarios)
6,5
6,5
Avatar del usuario
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 en 1 día
4,9 (389 comentarios)
6,6
6,6
Avatar del usuario
Ok Sure
$155 USD en 2 días
5,0 (136 comentarios)
6,6
6,6
Avatar del usuario
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 en 3 días
4,9 (92 comentarios)
6,3
6,3
Avatar del usuario
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 en 3 días
4,8 (94 comentarios)
6,2
6,2
Avatar del usuario
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 en 1 día
5,0 (98 comentarios)
6,2
6,2
Avatar del usuario
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 en 3 días
5,0 (83 comentarios)
5,8
5,8
Avatar del usuario
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 en 3 días
5,0 (150 comentarios)
5,8
5,8

Sobre este cliente

Bandera de CANADA
huntley, Canada
5,0
123
Forma de pago verificada
Miembro desde ago 24, 2005

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.