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.

Taidot: tietojenkäsittely, Excel, Visual Basic

Näytä lisää: 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

Tietoa työnantajasta:
( 82 arvostelua ) huntley, Canada

Projektin tunnus: #18201969

72 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 and have been featured by the freelancer community ( Lisää

$150 USD 0 päivässä
(648 arvostelua)

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 Lisää

$200 USD 2 päivässä
(299 arvostelua)

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

$110 USD 0 päivässä
(259 arvostelua)

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 päivässä
(133 arvostelua)

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 Lisää

$80 USD 0 päivässä
(202 arvostelua)

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. Lisää

$49 USD 0 päivässä
(424 arvostelua)

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 päivässä
(86 arvostelua)

"""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 Lisää

$100 USD 3 päivässä
(180 arvostelua)

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 Lisää

$190 USD 7 päivässä
(96 arvostelua)

Hello, I understand your requirements and i can provide you a based tool to generate the required output file. Please let me know if you are interested. Thanks

$48 USD 1 päivässä
(141 arvostelua)

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 Lisää

$100 USD 3 päivässä
(169 arvostelua)

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 Lisää

$250 USD 3 päivässä
(69 arvostelua)

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 päivässä
(284 arvostelua)

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 päivässä
(340 arvostelua)

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] Lisää

$55 USD 1 päivässä
(173 arvostelua)

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 Lisää

$100 USD 1 päivässä
(70 arvostelua)

Ok Sure

$155 USD 2 päivässä
(71 arvostelua)

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 Lisää

$98 USD 2 päivässä
(54 arvostelua)

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 Lisää

$100 USD 7 päivässä
(15 arvostelua)

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 Lisää

$55 USD 1 päivässä
(94 arvostelua)