Cleaning up and rearranging Text Data

[Old_Cadger]

Hi Guys.

I have vehicle fitment information provided to me by a manufacturer that needs to be rearranged so that it is usable by our system.

I am hoping that someone can help me out.

This is the information as it comes to me, it is in one cell.

[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"][/TD]
[/TR]
</tbody>[/TABLE]
CHEVROLET|||Year|Model|SubModel|Cylinders|Liter|Aspiration|Eng Desg.|Fuel|Notes|||2007 - 2013|AVALANCHE|ALL|ALL|ALL|ALL|ALL|ALL||||2002 - 2006|AVALANCHE 1500|ALL|ALL|ALL|ALL|ALL|ALL||||CHRYSLER|||Year|Model|SubModel|Cylinders|Liter|Aspiration|Eng Desg.|Fuel|Notes|||2005 - 2013|300|ALL|ALL|ALL|ALL|ALL|ALL||||GMC|||Year|Model|SubModel|Cylinders|Liter|Aspiration|Eng Desg.|Fuel|Notes|||1999 - 2013|SIERRA 1500|ALL|ALL|ALL|ALL|ALL|ALL||||2001 - 2007|SIERRA 1500 HD|ALL|ALL|ALL|ALL|ALL|ALL||||


The information is close to what I need.

I need to rearrange this information and add a line feed to each fitment type.
Year|Make|Model|Etc
I need the information to be as below in a cell with the line feed:

2007 - 2013|CHEVROLET|AVALANCHE|ALL|ALL|ALL|ALL|ALL|ALL
2002 - 2006|CHEVROLET|AVALANCHE 1500|ALL|ALL|ALL|ALL|ALL|ALL
2005 - 2013|CHRYSLER|300|ALL|ALL|ALL|ALL|ALL|ALL
1999 - 2013|GMC|SIERRA 1500|ALL|ALL|ALL|ALL|ALL|ALL
2001 - 2007|GMC|SIERRA 1500 HD|ALL|ALL|ALL|ALL|ALL|ALL

I am looking for a formula or VBA script that will identify the make and put it in the right location. And remove some unnecessary information and add carriage returns.

Thanks in advance.