I need to consolidate a csv file. Product attributes and id are row by row, they need to be moved to one row one product id. As few as 3 rows as many as 80 to consolidate. Our shopping cart requires "||" to separate attributes (for example s||m||l||xl||2x; blue||red||grey)
Check the finished product, done all by hand about 45 hrs. Would like a solution that can be used over again and again, as this should be done every 3 to 4 months.
The file comes to us as a comma delimited. Several columns can be deleted during consolidation.
* * *This broadcast message was sent to all bidders on Thursday Jul 17, 2008 5:01:33 PM:
It seems that as a first timer, I was lacking in my description of what I am trying to accomplish. It is hard for me to put into words. I have updated the zip file with a finished version. Done by hand about 60 hrs worth of work. Has to be an easier way. I am not stuck on using excel, but the end result must be a csv. Thanks for your efforts and bregards.