I have a files containing several hundred rows, some of them have duplicate values except for 1 column which is the quantity. For example:
row 1: content1,content2,12
row 2: content3,content4,7
row 3: content1,content2,5
row 4: content3,content4,1
etc
I need to take the rows with duplicate values and combine them, but I need to add the values qty column.
So for example, row 1 & row 3 have duplicate content, only the last column is different. So I need to combine them to 1 row then add the content of column the qty column.
So the final result should be
result: content1,content2,17
result: content3,content4,8
Let me know if you're able to do this.
Thanks
I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications.
Dear Sir,
I have read your job description & have understood your all requirement. I have also a big team to complete it earlier.
After seeing my previous record, You will decide that I will be the right person for you.
Now you can justify me and give me a chance to serve you.
Best regards
Md. Tanjir Hossain
Hi sir,
I am expert in excel Handling, i can create macro to sort out/remove any unwanted data(even from urls or from any where in the sheet). I have done 300+ excel tasks like matching the results, comparing using macro and i have well versedskill in sorting, replacing, delimations, duplicating,formulas etc. You will wonder if you see my work
Hi there,
I understand your project. I use advance Excel technique, formula and function to solve this problem. THIS CAN BE DONE BY DOING ASCENDING-DESCENDING THE COLUMNS AND USE TRIM AND OTHER FUNCTION. I have done several excel project successfully. I am ready to start immediately. Please PM me for discuss.
Thanks,
Mohiuddin.
Dear Client,
I have gone through the project description and I would like to offer my services for the same. I have worked on several similar projects.
I work as full time freelancer and have 11 years of experience in this field. I can reliably work on daily basis and perform the task as per your instructions.
I am a tech savvy person and I remain online for almost 14 hours a day. I am reachable through email or messengers.
I assure you I'll perform upto your satisfaction if given a chance.
Thanks
Sachin Gupta
Hello,
We could create a tool that you can use anythime you need.
Data processing by vba macro can be applied here in order to obtain the combined result.
My last VBA work includes:
- tool that automatically prepares PDF invoices using complex calculations
- tool that send emails automatically for each team leader containing only his team members+custom attachment
- import of one excel file within another in order to be processed following some configurable parameters
- vba tools with multiple forms, transfer data between windows forms
- data processing and reconciliation
I look forward to bring value and automate some tasks.
Cheers!
Marius
Hi, I read you project description and I'm Dynamic Professional has good command on Office tools like (Excel, Word, PowerPoint, Access and Data Entry). I will done it as per your requirement. Let's chat for further process. Thank You
Hello there, how are you today? I am very interested in doing this project and can start working on it after being discussed and awarded. Hoping to hear from you. Thank you and have a wonderful day. :)
Hi,
My name is Fedelito Recillo and I am a full-time freelancer. I see your job post and I am interested. I do believe that with my knowledge, skills and experience working on Elance/Upwork, I can do the job better than the others.
I already visualize what you want to be made in excel. Let us do it.
I am looking for a long term business relationship but I also do accept short term project.
Hope to hear you soon.
More power,
Fedelito Recillo
F&R Web Solutions
You want the columns with same value to be combined but the duplication in them should not be repeated rather that should be summarized.
I would like to discuss it with you. I have this feeling that I can do it for you :)
Hello,
I have seen your projects details and I want to do it. I have 3 years experienced on virtual assistant, data entry, web research,Visual Basic, MS excel job. According to my previous experienced I am sure I can do it perfectly. Please allow me to talk with you about this project. I think my previous experienced prove that I am the best candidate for this project. Thank you.
Regards,
Mrikongkan
hi
i am an excel expert and have read through your problem, i am keen to work on this and any other issues you are facing, please share with me the actual problem and i would be keen t help you.
I am online and readyt o discuss if you want.
Puneet
Hello there,
I have experience in excel data upload and data manipulation and implementation, and I'm interested in working in your project since the instructions are pretty much straight forward....
Look forward to discuss further upon acceptance.
Thank you.