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.
72 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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
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
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