I need a script that will take an existing csv file and create it in the format I need..
See the attached files:
Source file is located here: http://dl.dropbox.com/u/5146497/215_product.txt%20%281%29/215_product.txt
Here is a template file which explains what I need to convert the datafile into:
http://dl.dropbox.com/u/5146497/215_product.txt%20%281%29/template.xlsx
It contains a couple of extra sheets with further explanations of requirements e.g. how to create the category column,…
