Encerrado

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:
( 79 comentários ) huntley, Canada

ID do Projeto: #18201969

72 freelancers estão ofertando em média $103 para esse trabalho

jaylancer43

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
(648 Comentários)
8.3
schoudhary1553

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
(299 Comentários)
7.7
zExcel

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)
7.7
asin1987

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
(133 Comentários)
7.2
deepbluetech

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
(202 Comentários)
7.4
MimiFL

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
(424 Comentários)
6.8
maverick44000

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)
7.0
Tanmoy236

"""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
(180 Comentários)
6.7
zekovicm

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
(96 Comentários)
6.9
sumon355

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
(141 Comentários)
6.8
paris2785

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
(169 Comentários)
6.9
dgled

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
(69 Comentários)
6.8
TonmoyRoy111

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
(284 Comentários)
6.6
vano101

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
(340 Comentários)
6.4
koolsidz

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
(173 Comentários)
6.6
macroPOL

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
(70 Comentários)
5.7
periyannas

Ok Sure

$155 USD in 2 dias
(71 Comentários)
5.9
sonarkaushik

Sir, I am well versed in these kind of jobs and can do your project as per requirement. ***I am ready to start Waiting to hear from you. with thanks and regards Relevant Skills and Experience Data entry, exce Mais

$98 USD in 2 dias
(54 Comentários)
5.8
vaidyag

HI, I have excellent experience in C#, Excel and Access and other Microsoft related technologies. I have written complex macros like creating a BoM for an ERP, creating P/L, Cashflow statements from a database. I hav Mais

$100 USD in 7 dias
(15 Comentários)
5.3
mail2vimalarora

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
(94 Comentários)
5.8