Views fields as Columns in table

Question

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 ?

Answer 1

You could try to use Views aggregation.

1. Define the relationships of the fields.
2. Under Advanced > Other enable aggregation
3. Add fields of the animal nodes and define the grouping as "count" in the field's aggregation settings.
4. 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

Answer 2

Views Aggregator Plus does it. You don't necessary have to aggregate but it make a table as you want

Answer 3

In View -> "HEADER" section is available know.. Write HTML as separate table.

 <table><tr>
<th>Name</th><th>Age</th><th>Dogs</th><th>Cats</th><th>Mouse</th>
</tr></table>

and for field settings make it as grid.. and also you require above Views Flipped Table module. It's my small suggestion.