I have a content type "Awards" that has data structured as below:
I want to group this data as below:
Want to group them on a "State" basis. So when I click on mysite.com/TXawards, it should show data grouped as below:
Similarly "/FLaward" page should show data grouped as above. I don't have a view created yet but the content type with data is ready. What would be the best way to achieve this? I was thinking to use a contextual filter but I click the link "/TXawards" which is hardcoded on a page. Any help on how to group this data? Thanks
UPDATE: I created a"Table" styled view and grouped the rows by Type and State. The view output looks as below.

Can someone help with twigging this output to 2 column format pls?




