En cours

sku csv sorting

I am looking at a CSV with 80,000 rows+ of scooter parts.

As you might, or might not realise, particular parts (one SKU) fits on various machines, various particular machines. So, we are supplied by our primary parts supplier a CSV with all the SKU's row on row. so, one SKU will be listed 6 or more times, but with one bike model & make per row.

We require the CSV to function in a more appropriate fashion for our site (for a particular method of upload see this youtube [url removed, login to view]) - is have 1 row, per SKU with the Makes | (pipe) seperated and the Models pipe seperated?

Here's something of a demo (have and want) to perhaps better explain - [url removed, login to view]

will supply larger CSV on sucessful bid for project.

many many thanks in advance. We are a small two man company.

Please see this as an update:

Please ignore the "|" pipe requirements. We have been informed by our dev's that the original specified requirements were wrong. They have since supplied us with a new required CSV model and a PDF of specifications for each cell. This I apologise for.

Further, 1)Please we have 1 main large CSV. 2) As well as sheets split 500 rows. 2-500; 501,1000, etc – assuming row 1 = titles. (this is for image upload)

I have also posted the 14mb parts csv.

If possible, we work with LibreOffice here - please can you make sure of compatibility, or at least bear it in mind when working the files up.

with warm thanks in advance.

P









If anyone wishes to re-bid to upload this as well. Will provide admin login at the closure.

Compétences : Traitement de Données, Excel

Voir plus : www model fashion com, sorting of data, sorting method, models of fashion, method models, fashion model for man, fashion model com, www fashion model com, excel advance, sku, SCOOTER, Pipe, excel data sorting, csv to excel, csv site, advance excel, sorting supplier, sorting data, csv fashion, watch model, excel sorting, looking bike, data sku, youtube project excel, excel data csv

Concernant l'employeur :
( 0 commentaires ) Wivenhoe, Colchester, United Kingdom

N° du projet : #1672493

Décerné à :

lafor

It's already done. Details in PM.

65 $ USD en 0 jours
(121 Commentaires)
6.7

17 freelance ont fait une offre moyenne de 79 $ pour ce travail

Teloquence

Consider it done. Check your PM for my bid details.

100 $ USD en 2 jours
(204 Commentaires)
6.9
bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

100 $ USD en 3 jours
(65 Commentaires)
6.4
bouslimi1979

Please check PM. Thanks

50 $ USD en 1 jour
(59 Commentaires)
5.8
yourjmr

Hi! I have read and understood the project details. Check PMB for more details.

75 $ USD en 3 jours
(81 Commentaires)
5.4
srinichal

I can deliver all the required data

120 $ USD en 5 jours
(16 Commentaires)
5.3
datasolutionind

Ready to start !!!

30 $ USD en 2 jours
(48 Commentaires)
5.1
expertatwork

We are a team of 2 having a vast experience on excel VBA scripting. Looking forward to work with you. thanks !!! Please have a look at our message in your PMB.

40 $ USD en 1 jour
(61 Commentaires)
4.9
hemi

Please see more details on PMB. Thanks

60 $ USD en 1 jour
(27 Commentaires)
4.8
phpthebest

Hi I made this code , check PM.

30 $ USD en 0 jours
(5 Commentaires)
3.3
dicku2812

Let's Start........

30 $ USD en 1 jour
(3 Commentaires)
2.2
PatrickDev

Hi, I have worked on many projects like this in the past. I can make you a program to convert your CSV files in the fashion you are describing. I can set it as a standalone Perl script you run on your computer, or if y Plus

50 $ USD en 2 jours
(2 Commentaires)
2.0
tomkai

Hi, I can do this job.

50 $ USD en 1 jour
(3 Commentaires)
1.6
bpojobs2121

we want to be part of your team

250 $ USD en 5 jours
(0 Commentaires)
0.0
muhammadibaad

Sir, I have expertise in Webstore data manuplation and bulk data transfer,plz check pmb for more detail. Regards,

120 $ USD en 2 jours
(0 Commentaires)
0.0
jeniferbasil

Hi...I have an excellent command in Data Entry and spread sheets.I will give your work at [url removed, login to view] to have long term work with [url removed, login to view] my PM.

110 $ USD en 2 jours
(0 Commentaires)
0.0
gtorikt

I'M AVAILABLE FOR THIS TASK.

70 $ USD en 3 jours
(0 Commentaires)
0.0