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

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.

Skills: Data Entry, Data Processing, Excel, Visual Basic

See more: convert $50, rows, product sku, make a product, appropriate product, sample data input, excel sample project data, excel file convert, convert output, sheet data input sample, data sku, underscore, sample sheet data entry work, can convert project, sample size, excel sku, excel sheet product, sku data entry, product entry excel format, data entry sku

About the Employer:
( 2 reviews ) Honolulu, United States

Project ID: #5259794

Awarded to:


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 in 3 days
(17 Reviews)

7 freelancers are bidding on average $35 for this job


A proposal has not yet been provided

$34 USD in 1 day
(82 Reviews)

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

$73 USD in 1 day
(22 Reviews)

* 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 More

$25 USD in 1 day
(9 Reviews)

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.. More

$30 USD in 1 day
(11 Reviews)

Hello, We Have done many Data Entry project Completed With My [login to view URL] presently We have Joined with Freelancer A/c and We Can to do this project in without any [login to view URL] will try to complete your project in befo More

$30 USD in 1 day
(1 Review)

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 More

$25 USD in 1 day
(0 Reviews)