Make a script that convert product size data from rows to colums

Ολοκληρωμένο Αναρτήθηκε Dec 25, 2013 Πληρώθηκε κατά την παράδοση
Ολοκληρωμένο Πληρώθηκε κατά την παράδοση

I have an excel script project. I need an excel file that can convert the data on sheet1(INPUT) into a specific format on sheet 2 (OUTPUT). I attached a sample of the data and the format it needs to be converted to.

The work involves break apart the SKU into three rows. Then put the size data and price in the appropriate column.

The SKU is (column 2) - after the first underscore (_) the next 5 characters is the STYLE. The remainder of characters till the minus(-) is NUM. The next part is separated by Minus (-) is DESC. The last part of SKU is size.

Εισαγωγή Δεδομένων Επεξεργασία Δεδομένων Excel Visual Basic

Ταυτότητα Εργασίας: #5259794

Σχετικά με την εργασία

7 προτάσεις Απομακρυσμένη εργασία Ενεργό Dec 25, 2013

Ανατέθηκε στον:

EgyProgramer

hi, let me hear from you about this task i can start doing it now then you check the work before hiring me or anybody, it will take around 1-2 hours. let me hear from you

$25 USD σε 3 μέρες
(17 Αξιολογήσεις)
4.2

7 freelancers κάνουν προσφορές κατά μέσο όρο $35 για αυτή τη δουλειά

muzammil21

A proposal has not yet been provided

$34 USD σε 1 μέρα
(82 Αξιολογήσεις)
6.5
LearningNew

Sir, I have some queries................................................................................................................

$73 USD σε 1 μέρα
(22 Αξιολογήσεις)
5.3
sathyasingh1991

* OM SAI RAM * Respected Sir/Mam, I have read the project completely and I have understood my responsibilities (If awarded) clearly. To tell more about myself, I am dedicated and sincere in working on the pro Περισσότερα

$25 USD σε 1 μέρα
(9 Αξιολογήσεις)
3.5
harendersingh

Hi, Thanks for checking my proposal. I have worked for several Data Entry assignments in the past. References available to show related skills. Quoting Negotiable price range & can work perfectly for you.. Περισσότερα

$30 USD σε 1 μέρα
(11 Αξιολογήσεις)
3.5
vinod176singh

Currently I am Working in Tcs as a database developer. My main work is optimization of procedure and package used in project. I am new member of freelancer so i insure you i will perform good job because it will be h Περισσότερα

$25 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0