You can do this easily with the copy and paste, transpose, commands but it will put the data from columns B6, B7 & B8 in seperate columns such as columns C,D, & E for part number 10014. you would then have to delete rows 6,7, & 8 where the other vehicle data was.

For Part Number 10014 you do this by highlighting cells B6, B7, B8, and click the copy command, place your cursor into cell C5 to the right of the first vehicle's information, then click paste, transpose and the data from cells B6,7, & 8 will transfer to cells C5, D5 & E5.

I can see by your spreadsheet it would create a VERY wide spreadsheet especially for Part number 10115 with so many vehicles.