Converting column data into rows

I have a table of information which contains:

Owner Make 3rd Party Make
Mark Audi David BMW
Mark Audi Chris Volvo
Mark Audi Vik BMW
Ian BMW Fox Audi

and I need the information so I can see the owner on 1 line with the 3rd Party Makes.

Outcome:

Owner Audi BMW Volvo Nissan Honda
Mark Audi 0 2 1 0 0
Ian BMW 2 0 0 0 0
John Volvo 1 0 0 0 0
Paul Audi 0 0 1 1 1

I have tried using a VLOOKUP and COUNT however I can't seem to get it right. I have attached a sample however the original list runs into a few thousand Owners.

Hope someone can assist.