up vote
-2
down vote
favorite
I have a csv file like this >>>

1993    Chevrolet   Camaro  5.7L V-8    350 NULL    4.00 (in) / 4.00 (mm)   3.48 (in) / 88.4 (mm)   Base    2    
1994    Chevrolet   Camaro  5.7L V-8    350 NULL    4.00 (in) / 4.00 (mm)   3.48 (in) / 88.4 (mm)   Base    2    
1995    Chevrolet   Camaro  5.7L V-8    350 NULL    4.00 (in) / 4.00 (mm)   3.48 (in) / 88.4 (mm)   Base    2    
1996    Chevrolet   Camaro  5.7L V-8    350 NULL    4.00 (in) / 4.00 (mm)   3.48 (in) / 88.4 (mm)   Base    2    
1997    Chevrolet   Camaro  5.7L V-8    350 NULL    4.00 (in) / 4.00 (mm)   3.48 (in) / 88.4 (mm)   Base    2    
1998    Chevrolet   Camaro  5.7L V-8    350 NULL    3.90 (in) / 3.90 (mm)   3.62 (in) / 92.0 (mm)   Base    2    
1999    Chevrolet   Camaro  5.7L V-8    350 NULL    3.90 (in) / 3.90 (mm)   3.62 (in) / 92.0 (mm)   Base    2    
2000    Chevrolet   Camaro  5.7L V-8    350 NULL    3.90 (in) / 3.90 (mm)   3.62 (in) / 92.0 (mm)   Base    2    
2001    Chevrolet   Camaro  5.7L V-8    350 NULL    3.90 (in) / 3.90 (mm)   3.62 (in) / 92.0 (mm)   Base    2    
2002    Chevrolet   Camaro  5.7L V-8    350 NULL    3.90 (in) / 3.90 (mm)   3.62 (in) / 92.0 (mm)   Base    2    
1994    Chevrolet   Caprice 5.7L V-8    350 NULL    4.00 (in) / 4.00 (mm)   3.48 (in) / 88.4 (mm)   Classic 2    
1995    Chevrolet   Caprice 5.7L V-8    350 NULL    4.00 (in) / 4.00 (mm)   3.48 (in) / 88.4 (mm)   Classic 2    
1996    Chevrolet   Caprice 5.7L V-8    350 NULL    4.00 (in) / 4.00 (mm)   3.48 (in) / 88.4 (mm)   Classic 2    
1993    Chevrolet   Corvette    5.7L V-8    350 NULL    4.00 (in) / 4.00 (mm)   3.48 (in) / 88.4 (mm)   40th Anniversary Edition    2    
1992    Chevrolet   Corvette    5.7L V-8    350 NULL    4.00 (in) / 4.00 (mm)   3.48 (in) / 88.4 (mm)   Base    2    
1994    Chevrolet   Corvette    5.7L V-8    350 NULL    4.00 (in) / 4.00 (mm)   3.48 (in) / 88.4 (mm)   Base    2    
1995    Chevrolet   Corvette    5.7L V-8    350 NULL    4.00 (in) / 4.00 (mm)   3.48 (in) / 88.4 (mm)   Base    2    
1996    Chevrolet   Corvette    5.7L V-8    350 NULL    4.00 (in) / 4.00 (mm)   3.48 (in) / 88.4 (mm)   Base    2
The first column is the year and then we have make, model, engine[/QUOTE]

I need to generate and output a csv like this >>>>

sku parts

111 1993 (to) 2002>Chevrolet>Camaro;1994 (to) 1996>Chevrolet>Caprice;1993 (to) 1996 >Chevrolet>Corvette    
222 1993 (to) 2000>Ford>Mustang; ...
the first column will be the part number, and the second is the rest of the information under parts