I need to modify a csv to output data in a different way

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

Originally Posted by davesexcel

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

ok I just added a sample workbook, the first sheet is the source the second the output I need automated.