a script that creates duplicate rows from columns in excel

Closed - This job posting has been filled and work has been completed.
Accounting & Consulting Other - Accounting & Consulting Posted 1 year ago

Fixed Price

Delivery by December 24, 2013

$7.00

Budget

Details

I need a script that would transpose an excel sheet with many columns into a sheet with 2 columns, but the 1st
e.g.
take the document
id    |  tag 1       |  tag 2   |  tag 3
112 |  apples     |  cat      |  dog
eer  |  love         |  table   |  sometag

into

id    | tag
112 | apples
112 | cat
112 | dog
eer | love
eer | table
eer | sometag

the sheet has ~500K rows and ~10 columns per row, so make sure your script can handle large amounts of data.


About the Client

(4.98) 99 reviews

United States
Sf 08:41 AM

125 Jobs Posted
71% Hire Rate, 1 Open Job

Over $50,000 Total Spent
141 Hires, 1 Active

$20.10/hr Avg Hourly Rate Paid
4,287 Hours

Member Since Sep 3, 2013