View Table Format with a group by

Question

Is there a way to create a group by in a table views.

Here is how I would like that the group by looks like

Answer 1

Here is a module that does exactly the same as you want.

From Module page.

Create a new view (eg: a list of node). Set format Table Rowspan for this view. Add some field to this view. Group field that has same value. Check option "Merge rows in group".

Click on settings and group by your results by Principal, Guest, Email Member, Non Email Member. This module will render your table in exactly the same format you want.

Answer 2

You can use Views Merge Rows to achieve this.

The Views Merge Rows module provides a way to combine rows with the same content in the specified fields.

I use this module in a project and it works fine.