Access – Combining Fields to one record

I have a table that lists let’s say
Type Color
car blue
car red
car yellow
truck red
truck blue and so on
Need to make new table and combine all the cars in one record and list the color as blue, red, yellow in that one record. Make sense? Car red, yellow, blue