Creating a pivot table from a complicated data structure

[poiu]

Hello,

I have data in the below structure:


Car Brand: Ford Ford Toyota Toyota

Car Type: Pickup Saloon Pickup Saloon
Colour
Blue $11,000 $15,000 $14,000 $13,000
Red $12,000 $13,000 $14,000 $12,000
Pink $11,000 $12,000 $18,000 $19,000
Green $18,000 $12,000 $17,000 $13,000

Is it possible to get this data structure into a pivot table? Or do I need to manually move everything into the following structure? (I'm dealing with a big data set and this would take hours):

Car Brand Car Type Colour Price
row1
row2
row3 etc

Thanks for your help!

poiu