Find Jobs
Hire Freelancers

Excel Data Merge in a Specific Format

£10-20 GBP

Completed
Posted almost 6 years ago

£10-20 GBP

Paid on delivery
Please see the attached file, this should be a simple job for someone who knows what they are doing. Basically, for each SKU, using ‘PPGC00005’ as an example. Would need to change:- PPGC00005 1 Name On Front 12 1 PPGC00005 2 Message On Front 20 1 PPGC00005 3 Message Line 1 Inside 20 0 PPGC00005 4 Message Line 2 Inside 20 0 PPGC00005 5 Message Line 3 Inside 20 0 PPGC00005 6 Message Line 4 Inside 20 0 PPGC00005 7 Message Line 5 Inside 20 0 to:- PPGC00005|PPGC00005|PPGC00005|PPGC00005|PPGC00005|PPGC00005|PPGC00005 1|2|3|4|5|6|7 Name On Front|Message On Front|Message Line 1 Inside|Message Line 2 Inside|Message Line 3 Inside|Message Line 4 Inside|Message Line 5 Inside 12|20|20|20|20|20|20 1|1|5|5|5|5|5 So column A1 would be:- PPGC00005|PPGC00005|PPGC00005|PPGC00005|PPGC00005|PPGC00005|PPGC00005 1|2|3|4|5|6|7 column A2:- Name On Front|Message On Front|Message Line 1 Inside|Message Line 2 Inside|Message Line 3 Inside|Message Line 4 Inside|Message Line 5 Inside and so on... In the Excel there is around 20,000 records, but yeah we’re basically combining the column separated by | For each SKU if that makes sense o we will still have 5 columns, A - E, just a lot less rows as each row will be a unique SKU
Project ID: 17216458

About the project

33 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at [login to view URL] (username - sourabhg98) with over 400 questions answered and 1100 reputation points. I would like to offer my services for this project. I can easily use an excel VBA script to convert data to the desired format. As far as I have understood, you are basically looking to be able to combine the rows with similar SKUs into one row separated by |. I can begin with the work right now and provide the output within 20 minutes. I will also provide the script so you can use it in future for some other data. I assure the best in class services and fairest prices. Would wait for a positive and prompt response from your side :) Regards Sourabh
£10 GBP in 1 day
5.0 (135 reviews)
5.9
5.9
33 freelancers are bidding on average £18 GBP for this job
User Avatar
yes we can do it.. but the the result will be in 1 row.. is that correct. we can get you the output. the single grid will not accept 20,000 records, we can separate 5000 each for 4 rows
£20 GBP in 1 day
4.9 (337 reviews)
8.2
8.2
User Avatar
Hi, i m serious freelancer with 100% completion rate and i believe i can automate this for you. If you are interested feel free to message me. I've completed many similar projects and i've never had a single problem. Basically we just need to detect each section and merge them together. Thanks, Milan
£18 GBP in 0 day
5.0 (536 reviews)
7.0
7.0
User Avatar
Hello, I just checked the .csv file and very much interested to do this work. I want to do this task manually without using any software because I want to provide you a good quality work. With software there will be a change to have some mistakes that's why I always avoid this. Please let me know the timeline for this project. I can start this from now. Awaiting an affirmative response from you. Kind regards, Roy.
£20 GBP in 1 day
4.9 (385 reviews)
7.3
7.3
User Avatar
I have downloaded the attached file,but it is a csv and not an excel file so we can not directly put excel VBA over it. 1- i can easily write a code to the merging as described 2-Column A1 to A5 will be delivered as a merged output file 3-Will output file in csv format or xlsx(excel based). Looking forward to have a chat with you to discuss further. I will do it in one hour.
£20 GBP in 1 day
5.0 (125 reviews)
6.5
6.5
User Avatar
I am an experienced Data Analyst with advanced skills in Excel. I have done a lot of projects like this one in the past for various companies and i have over 8 years experience in the field. I would be glad if you give me the opportunity to show you what i can do. Thanks!
£20 GBP in 1 day
5.0 (47 reviews)
6.4
6.4
User Avatar
I can work for you. I'm interested in your project. I've an experience of works with ms excel and vba. Ping me any time to discuss about this project.
£18 GBP in 1 day
5.0 (12 reviews)
5.2
5.2
User Avatar
Hello sir, I am ready to do this project. If u give me one chance to show my quality work then i will be greatfull. For more information about me, Please check my profile and reviews. Thanks Ruchi
£23 GBP in 3 days
5.0 (41 reviews)
5.2
5.2
User Avatar
hi! I can help you with your project. Maybe its better to use publisher than the word. anyway you will be the one to decide. thanks
£15 GBP in 1 day
5.0 (30 reviews)
4.6
4.6
User Avatar
hi, I am very good in excel vba, macro. if you want to see my skills on excel I will share with you some of my stuff. I feel fit for the project. please contact with me. thanks
£18 GBP in 1 day
4.8 (28 reviews)
4.9
4.9
User Avatar
I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, chart, advance formulas, formatting, macros, etc. thanks
£28 GBP in 1 day
4.9 (24 reviews)
4.0
4.0
User Avatar
Hi, It is possible to do so. I can do it for you immediately. I am expert in Excel having 12 years Professional experience in it. I’ll complete task with 100% Accuracy and in least possible time. I assure you, you will be another 100% satisfied client. Thanks.
£18 GBP in 1 day
5.0 (19 reviews)
4.0
4.0
User Avatar
I can do this in one day with a small program that takes your file as input and outputs another file in the format you have described in your details. If you like the output, we can give you the program for little extra cost with steps to operate it so you can convert many files with it.
£18 GBP in 1 day
5.0 (3 reviews)
3.3
3.3
User Avatar
Hello, I will be happy to deal with this project. I have a lot of experience in this type of projects. Regards, Tomasz Pawlak
£18 GBP in 2 days
5.0 (1 review)
2.1
2.1
User Avatar
Hi Dear, I am professional at excel and have good experience. I don't have any ongoing projects right now.. so your work will be priority for me.. I will finish your job as fast as possible. Thanks
£18 GBP in 1 day
5.0 (2 reviews)
1.7
1.7
User Avatar
I download your file and I can finish your work fast and high accueratly .because I have experience in excel
£10 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
i have 5 years exp in excel. i will do ur work in one day. i will do that rows to columns total data please accept my bid thank you
£18 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have fruitful experience on data merge and data integration in the specific format. You can get a completed data set and perfect format for what you need through cooperating with me.
£18 GBP in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hello, i'm Mr. Pho nice to meet you. i can do it this job with me, excel is simple. believe me. thanks!
£13 GBP in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do any type of excel works. Can you provide the details on how I can help your project? I have been using excel for more than 10 years now mostly post processing data, calculation and macros. I am willing to help you and give you best results you can have.
£13 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Specialized in: 01. Database & Website plan, design & develop. 02. E-commerce , Application based , Dynamic, Static web site design & development. 03. SQL Server, Access, My SQL, Oracle. 04. PHP, JAVA, WordPress.
£23 GBP in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Ibstock, United Kingdom
5.0
20
Payment method verified
Member since May 17, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.