Find Jobs
Hire Freelancers

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

$30-250 USD

进行中
已发布超过 5 年前

$30-250 USD

货到付款
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: 18201969

关于此项目

65提案
远程项目
活跃5 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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 在1天之内
0.0 (0条评论)
0.0
0.0
65威客以平均价$100 USD来参与此工作竞价
用户头像
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 在3天之内
5.0 (218条评论)
7.9
7.9
用户头像
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 在2天之内
4.9 (403条评论)
8.1
8.1
用户头像
Hi I'd be happy to provide the macro for this task. Can deliver solution within a few hours . . ,
$110 USD 在0天之内
4.9 (261条评论)
7.7
7.7
用户头像
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 在0天之内
5.0 (580条评论)
7.2
7.2
用户头像
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 在0天之内
5.0 (204条评论)
7.4
7.4
用户头像
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 在3天之内
4.9 (278条评论)
7.7
7.7
用户头像
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 在7天之内
4.9 (151条评论)
7.5
7.5
用户头像
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 在1天之内
4.9 (435条评论)
7.2
7.2
用户头像
"""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 在3天之内
4.9 (264条评论)
7.0
7.0
用户头像
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 在3天之内
4.9 (92条评论)
7.2
7.2
用户头像
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 在1天之内
5.0 (168条评论)
7.1
7.1
用户头像
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 在2天之内
5.0 (89条评论)
7.0
7.0
用户头像
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 在3天之内
5.0 (120条评论)
6.5
6.5
用户头像
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 在1天之内
4.9 (389条评论)
6.6
6.6
用户头像
Ok Sure
$155 USD 在2天之内
5.0 (136条评论)
6.6
6.6
用户头像
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 在3天之内
4.9 (92条评论)
6.3
6.3
用户头像
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 在3天之内
4.8 (94条评论)
6.2
6.2
用户头像
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 在1天之内
5.0 (98条评论)
6.2
6.2
用户头像
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 在3天之内
5.0 (83条评论)
5.8
5.8
用户头像
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 在3天之内
5.0 (150条评论)
5.8
5.8

关于客户

CANADA的国旗
huntley, Canada
5.0
123
付款方式已验证
会员自8月 24, 2005起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。