Grouping COLUMNS.
 

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

Grouping COLUMNS.
 

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.

"stevepru" wrote:

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

Grouping COLUMNS.
 

DataGroup and OutlineGroup 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?searc...uping+in+excel


"stevepru" wrote in message
...
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