Retrieving multiple data from db and grouping them

Retrieving multiple data from db and grouping them

I'm looking for a sql command solution for this problem. I want to
retrieve all the rows that have the same atribute and list them. I've
tried group by, but it merges the results into one row per chosen field. I
want to retrieve the multiple results to do something like:
black
nissan
toyota
red
ferrari
yellow
porsche
lambo