Basically I have some data which is organised like this :

--------------------------------------------------------------------------
Date | Q1 | Q2 | Q3 | Q4 | Q5 |
--------------------------------------------------------------------------
08/18 | Yes | No | Yes | No | Yes |
--------------------------------------------------------------------------
07/18 | No | Yes | No | No | No |
--------------------------------------------------------------------------
07/18 | Yes | Yes | Yes | No | Yes |
--------------------------------------------------------------------------
08/18 | Yes | No | No | Yes | No |
--------------------------------------------------------------------------


I'd like to use maybe pivot table or something else to display the information like this :

-------------------------------------------------------------------
| Q1 | Q2 | Q3 | Q4 | Q5 |
--------------------------------------------------------------------------
Yes | 3 | 2 | 2 | 1 | 2 |
--------------------------------------------------------------------------
No | 1 | 2 | 2 | 3 | 2 |
--------------------------------------------------------------------------

and use the date a sorting mechanism to dynamically change the output

How can I achieve this? Any tips or ideas?