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 2 years ago

Fixed Price

Budget: $7
Delivery by December 24, 2013

Start Date

November 4, 2013

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) 100 reviews

United States
Sf 02:10 AM

127 Jobs Posted
71% Hire Rate, 1 Open Job

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

$19.82/hr Avg Hourly Rate Paid
4,381 Hours

Member Since Sep 3, 2013