Grouping COLUMNS.

[stevepru]

Hi, how do I group columns like you group rows ? I'm trying to create a
grouped column for each month and the individual weeks as columns that could
be grouped by month. I can group jan wk1-4 but when i try to do the same for
feb it just extends the group from jan to include feb. I want be able to '+
expand' & '- collapse' each month independently. Idea's ?

January February
wk1; wk2; wk3; wk4 wk1; wk2; wk3; wk4

 

[Alojz]

Hi, u need separate column for each month which will be not grouped with week
columns. Either leave this separate column blank or fill it with aggregate
value for given month (e.g. sum of values for all weeks in the month), but do
not group this column with other (weeks) columns.

 

[Paul]

Data>Group and Outline>Group then pick column option in dialog box. (XL
2003)

A couple of useful links:
http://www.wikihow.com/Group-and-Outline-Excel-Data
http://exceltip.com/exceltips.php?view=category&ID=30 (including on how to
do it in XL 2007)

for instructional videos:
http://www.youtube.com/results?search_type=&search_query=grouping+in+excel&aq=0&oq=grouping+in+excel