Em Andamento

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

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.

Habilidades: Processamento de dados, Excel, Visual Basic

Veja mais: php script send email specific email address, script import email address file, confirm email address script, script remove duplicate email, perl script email address symbol, import email address book script, convert email address excel, html confirm email address script, script captures email address website visitors, email address validity python script, want export email address inbox excel, send email address excel, php script delete mysql duplicate rows, free php script import email address book, php script yahoo email address check, need email address different companies pakistan, simple email address capture script, script import email address, excel 2007 merge duplicate cells

Acerca do Empregador:
( 95 comentários ) huntley, Canada

ID do Projeto: #18201969

Concedido a:


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 delimit Mais

$30 USD em 1 dia
(0 Comentários)

69 freelancers estão ofertando em média $102 para esse trabalho


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Mais

$150 USD in 0 dias
(702 Comentários)

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 Mais

$200 USD in 2 dias
(329 Comentários)

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 dias
(162 Comentários)

Hi I'd be happy to provide the macro for this task. Can deliver solution within a few hours . . ,

$110 USD in 0 dias
(259 Comentários)

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. Re Mais

$80 USD in 0 dias
(204 Comentários)

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 sc Mais

$100 USD in 3 dias
(203 Comentários)

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 em 1 dia
(146 Comentários)

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. Mais

$49 USD in 0 dias
(485 Comentários)

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 agr Mais

$190 USD in 7 dias
(113 Comentários)

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 Applicat Mais

$250 USD in 3 dias
(78 Comentários)

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 dias
(86 Comentários)

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 em 1 dia
(318 Comentários)

"""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 m Mais

$100 USD in 3 dias
(211 Comentários)

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 em 1 dia
(349 Comentários)

NOTE: This is a temporary bid. Please share exact details so that I can give you an exact bid My Credentials: 20+ of VB Experience. [login to view URL] [login to view URL] Mais

$55 USD em 1 dia
(174 Comentários)

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 dias
(95 Comentários)

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 Mais

$100 USD em 1 dia
(96 Comentários)

Ok Sure

$155 USD in 2 dias
(103 Comentários)

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macr Mais

$45 USD em 1 dia
(62 Comentários)

Hello, I am ready to discuss project with you. Being experienced in working on several excel vba scripts, I can help with macro that will identify duplicate rows and consolidate accordingly as mentioned in the desc Mais

$55 USD em 1 dia
(104 Comentários)