parsing in excel directory of makes and models of cars

Good day.
You want to parse

Format four post brand – model – body – modification
In the example above should look as in the attachment, the example in the attachment is perfected solely by couze