Group by category

[mjhaston]

I have a pretty quote spreadsheet I am populating form a data source spreadsheet (JSON feed). If I have a CATEGORY column, how can I group by that column and break when CATEGORY changes? So I'd list it something like this:

Name 1 - VIDEO GAMES
Name 2 - VIDEO GAMES
Name 3 - VIDEO GAMES

Name 1 - MERCHANDISERS
Name 2 - MERCHANDISERS
Name 3 - MERCHANDISERS


I'd like to make the CATEGORY the heading:
VIDEO GAMES
- Name 1
- Name 2
- Name 3

MERCHANDISERS
- Name 1
- Name 2
- Name 3

I also like to have a footer for each breakdown with sub-total.


Thanks in advance. I'll post another question to my other task. Trying to figure out the best approach to being able to change the data source, possibly based on the OneDrive url.