Views fields as Columns in table I have a content type called Pets, which only has title and description. In Pets there are only 3 data (set by Admin) Cats, Dogs and Mouse. User can select only from these data and cannot add more Pets.

After the Girls register in the site they can hit the checkbox to select the pets they have in their profile. 

However, I want to have a Views table where I want to list the Girls' profile like: (that's the table I wanted to make)

Name ------ Age -------- Dogs ---------- Cats ----------- Mouse
Tina ----------- 21 ------------ Yes ---------------- No ----------------- No
Lita ----------- 27 ------------- No ---------------- Yes ----------------- Yes

When I add Pets title in the views it just shows as:

Title
Dogs
Cats
Mouse

but I want to change the fields(dogs, cats, mouse) as Columns and have Yes or No in the rows. I just tried Views Flipped Tables Module but wasn't able to do with it. any suggestions please ?
You could try to use Views aggregation.


Define the relationships of the fields.
Under Advanced > Other enable aggregation
Add fields of the animal nodes and define the grouping as "count" in the field's aggregation settings.
Define no results bahaviour as "No" and rewrite the result as "Yes". Define 0 as "no result". All in the field settings.


Hope that helps!

cheers,
j