Data Manipulation of 4 column spreadsheet

Dear Freelancers

I have a spreadsheet with 2200 products.

In the spreadsheet are 3 columns containing Colour Size and Cost of the product.

Some product entries have multiple lines.

The majority of entries in the current data layout are like GD58 shown below.

Some are more complicated like GD05

This is the Current Data layout

GD05 White/Natural S - XXL £1.75

GD05 White/Natural 3XL £2.05

GD05 Ash/Sports Grey S - XXL £2.00

GD05 Ash/Sports Grey 3XL £2.30

GD05 Colours S - XXL £2.10

GD05 Colours 3XL £2.45

GD58 All Colours All Sizes £8.65

This is the New data layout I want

Fld1 Fld2 Fld3 Fld4 Fld5 Fld6 Fld7 Fld8 Fld9 Fld10 Fld11 Fld12 Fld13 Fld14 Fld15 Fld16

GD05 White/Natural S - XXL £1.75 3XL £2.05 Ash/Sports Grey S - XXL £2.00 3XL £2.30 Colours S - XXL £2.10 3XL £2.45

GD58 All Colours All Sizes £8.65

The majority of entries in the current data layout are like GD58 it is just some are more complicated like GD05

I want this done within a maximum time of 24 hours. Do not bid if you can not complete within 24 hours.

Do not PM me under any circumstances.

Anyone who sends a PM with their bid will be ignored, please put all the information in the bid.

I only use PMs to discuss work in progress.

Thank you for reading my offer of work.

Taidot: tietojenkäsittely, Excel, MySQL, PHP

Näytä lisää: sports freelancers, freelancers under 10.00, spreadsheet manipulation, progress data, spreadsheet columns, work hours spreadsheet, layout column, natural data processing, product entries, grey pms, data sports, entries spreadsheet, product spreadsheet, need spreadsheet business card data, spreadsheet column, spreadsheet record missing data, spreadsheet showing raw data, excel spreadsheet analyze stock data, pms grey, spreadsheet products, sports data spreadsheet, silver light stacked column charts data table, oracle column based data, manipulation php, data manipulation php

Tietoa työnantajasta:
( 66 arvostelua ) Royal Borough of Greenwich, Isle of Man

Projektin tunnus: #4234487