mjhaston

New Member
Joined
Dec 26, 2017
Messages
2
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.

grouping.PNG
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Watch MrExcel Video

Forum statistics

Threads
1,123,329
Messages
5,600,997
Members
414,419
Latest member
JRDunya

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top