CSV excel file, duplicate row and change value

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

i need a quick way to enter 650 coupon codes into excel file.

duplicate a row and change value of 2 cells

one cell will be based on random codes from another excel file.

Example:

7;"11";"1";"0";"{""gravityForm"":""11"" couponName"":""event namel"" couponCode"":""UKF4P"" couponAmountType"":""flat"" couponAmount"":17 startDate"":"""" endDate"":"""" usageLimit"":""1"" isStackable"":""0"" usageCount"":""""}";"gravityformscoupons"

8;"11";"1";"0";"{""gravityForm"":""11"" couponName"":""event namel"" couponCode"":""XDBAD"" couponAmountType"":""flat"" couponAmount"":17 startDate"":"""" endDate"":"""" usageLimit"":""1"" isStackable"":""0"" usageCount"":""""}";"gravityformscoupons"

the 1st digit is an increment by 1

and the coupon code will also be updated.

its actually a sql csv data file.

Data Entry Data Processing Excel PHP Visual Basic

Project ID: #15762497

About the project

11 proposals Remote project Active 6 years ago

Awarded to:

kahilH

Hello I suggest to automate the process by a simple script done in java Lets discuss more on chat about the project Relevant Skills and Experience Highly skilled data processor

$25 USD in 1 day
(23 Reviews)
4.7

11 freelancers are bidding on average $21 for this job

P0L

Hello, I’m an Excel expert/VBA and I can help you right away. Please check my profile and contact me to discuss. Regards. Stay tuned, I'm still working on this proposal.

$25 USD in 1 day
(210 Reviews)
6.8
ReliableMate

Need to increment each row by 1 by duplicating the rows to generate a number of coupon Relevant Skills and Experience Excel, Data Entry Proposed Milestones $20 USD - Work

$20 USD in 0 days
(84 Reviews)
6.4
abhi98041

i am a excel expert and i can do your job.

$15 USD in 1 day
(37 Reviews)
4.3
creativelive2010

Hi, I am expert Graphic designer and wordpress developer, Please a look at my portfolio on my profile for more satisfactions. Waiting for your happy response Relevant Skills and Experience I am expert in required sk More

$25 USD in 1 day
(11 Reviews)
3.5
SoufianeAch

Hi ! I have experience in excel and data processing. I have completed many tasks requiring these skills during my internships for automating processes. I am very rigorous, accurate and aware of the responsibility give More

$13 USD in 1 day
(2 Reviews)
2.4
jodenzle

negotiable based on project. Relevant Skills and Experience HI, I am interested with this job, kindly message me a break down detail of this work, i've seen the excel file. Proposed Milestones $30 USD - clients decis More

$30 USD in 1 day
(0 Reviews)
0.0
ria4mail

A proposal has not yet been provided

$30 USD in 1 day
(0 Reviews)
0.0
adediranp

Thank you for posting this job here. I am more than willing to help you achieve success on this project. Give me the details. Let me start pouring myself in as a Spreadsheet and Data Entry expert. Relevant Skills and More

$13 USD in 1 day
(0 Reviews)
0.0