Sub grouping of a column

[azkhan]

I have a table of used cars with many columns. I have created a new table with car makes and colors. I am trying to make a table which shows column names as colors and makes as the rows. Can somebody help me?

Table name- used cars

Column name - make

column name - colors

Thanks 

Khan