Group by Context

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
rtod2Asked:
Who is Participating?
 
winthropjConnect With a Mentor Commented:
This is using the Group functions. I'm using 2007 and this was a manipulation of the Subtotal grouping feature.
Course-Schedule-F2010.xls
0
 
winthropjCommented:
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
0
 
rtod2Author Commented:
I was hopeful that I could get a grouping with the little plus and minus next to it.
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
winthropjCommented:
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
0
 
rtod2Author Commented:
Still pretty raw.  I'm using Excel 2010.  Thanks for the assist.
0
 
rtod2Author 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.
0
 
winthropjCommented:
A little prettier?
Course-Schedule-F2010.xlsx
0
 
rtod2Author Commented:
Looks a little cleaner, but now I can't insert a row under one of the groups?
0
 
winthropjCommented:
Throw that pivot table screen shot up and I'll see if I can help you get where you want to be.
0
 
rtod2Author Commented:
0
 
rtod2Author Commented:
seems like the best solution, thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.