Can I have groups without a column in between

[lezawang]

Hi
I want to group column Jan-March in one group and then April-Jun into different group. I can not do that. I can group Jan-March but then when I try to group April-June, excel merge them into one group from Jan-June
Can I have groups without a column in between? Thank you very much

Book1
	A				E	F	G	H	I	J	K	L	M
1	Item				apr	may	jun	jul	aug	sep	oct	nov	dec
2	Item1				1	1	1	1	1	1	1	1	1
3	Item2				1	1	1	1	1	1	1	1	1
4	Item3				1	1	1	1	1	1	1	1	1
5	Item4				1	1	1	1	1	1	1	1	1
6	Item5				1	1	1	1	1	1	1	1	1
7	Item6				1	1	1	1	1	1	1	1	1
8	Item7				1	1	1	1	1	1	1	1	1
9	Item8				1	1	1	1	1	1	1	1	1
10	Item9				1	1	1	1	1	1	1	1	1
11	Item10				1	1	1	1	1	1	1	1	1
12	Item11				1	1	1	1	1	1	1	1	1
13	Item12				1	1	1	1	1	1	1	1	1
Sheet2

 

[Peter_SSs]

Can I have groups without a column in between?

No. Suppose you could. Below I have grouped and collapsed columns B:D. If I was now able to separately group E:G and collapsed those columns as well, the grouping symbol for B:D would disappear and you would not be able to expand B:D