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
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 (177 reviews)
6.3
6.3
32 freelancers are bidding on average £18 GBP for this job
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
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
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.
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.
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!
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
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
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
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.
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
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.
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.