Group by Context

rtod2
rtod2 used Ask the Experts™
on
I want to group the items in this sheet by the Context in column D such that the entire group can be expanded and contracted easily.  I've tried making the pivot table but am unclear on how to get the output I want from there, or if that is even the feature I should be using.

Assistance is greatly appreciated.
Course-Schedule-F2010.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Not exactly sure what the desired output is but try using the auto filter of just filter in version 2007 and up. It will give you a drop box in the header of column D and then you can pick which course context to display.
Course-Schedule-F2010.xls

Author

Commented:
I was hopeful that I could get a grouping with the little plus and minus next to it.
This is using the Group functions. I'm using 2007 and this was a manipulation of the Subtotal grouping feature.
Course-Schedule-F2010.xls
Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

I think this is better. I added a column and gave it the labels for the courses then selceted and made the groups. Which version of excel are you using?
Course-Schedule-F2010.xls

Author

Commented:
Still pretty raw.  I'm using Excel 2010.  Thanks for the assist.

Author

Commented:
Here is a screenshot of the pivot table function but I am still not quite there.  Trying to group by context using the pivot tables.

Author

Commented:
Looks a little cleaner, but now I can't insert a row under one of the groups?
Throw that pivot table screen shot up and I'll see if I can help you get where you want to be.

Author

Commented:
seems like the best solution, thank you

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial