Problem with data Grouping

[mrmmickle1]

I want to group rows below blank values in column 3. I have the following data:

Excel 2010
	A	B	C	D	E	F
1		Veneer SKU	07/25/2011	08/01/2011	08/08/2011	08/15/2011
2		Face
3	Face	125063 NRO Face .169	2632	5208	10304	4760
4	Face	125284 SRO Face .119	92657.5	72080	82922.5	76952.5
5	Face	125149 SRO Face	110980	167285	127380	77051
6	Face	125106 Maple Face	12063	22288	16040	27964
7	Face	125073 Walnut Face	7680	14432	6384	7398
8	Face	125067 Cherry Face	10256	13020	5768	9744
9	Face	125071 Hickory Face	26606	29042	29804	20548
10	Face	125100 Birch Face	5432	7084	11172	5320
11	Face	125251 Pecan Face - PUMA	0	587444	63206	81796
12	Face	125263 SRO Face 50.75	480545	237745	231925	196115
13	Face	125286 NRO Face .119	8184	16895	7936	10602
14	Face	125181 Hickory Face 46"	3806	4774	9130	24354
15	Face	125082 Maple Face 46"	6820	3674	3894	7458
16	Face	125049 Red Oak Face 46"	28864	41426	33352	26840
17	Face	125099 Cherry Face 46"	3190	1452	1540	4224
18	Face	125142 Walnut Face 46"	2112	3498	2970	2618
19	Face	GFWIMO448.080SIC Curry Oak Face	0	0	0	1760
20	Face	GFWIMWO448.080SIC Curry White Oak Face	0	0	0	0
21	Face	GFWIMB448.080SIN Curry Birch Face	0	0	0	0
22	Face	GFWIMC448.080SIC Curry Cherry Face	0	0	0	0
23	Face	GFWIMH448.080SIN Curry Hickory Face	0	0	0	0
24	Face	GFWIMM448.080SIC Curry Maple Face	0	0	0	0
25	Face	GFWIMW448.080SIN Curry Walnut Face	0	0	0	0
26	Face	125007 Oak Face .125 X 48.25 X 48	8271	6860	1440	13424
27	Face	125152 Maple Face 48.25 X 48.25	0	0	0	0
28	Face	125238 Pecan Face .125 X 48.25 X 48	160	1350	16	0
29		Back
30	Back	125064 NRO Back .169	2632	5208	10304	4760
31	Back	125285 SRO Back .119	100842	88975	90858.5	87554.5
32	Back	125148 SRO Back	173017	840595	259754	229821
33	Back	125264 SRO Back 50.75	480545	237745	231925	196115
34	Back	125050 Red Oak Back 46"	44792	54824	50886	65494
35	Back	125008 Oak Back .125 X 48.25 X 48	8431	8210	1456	13424
36	Back	125148 SRO Back/No Acclimation	0	0	0	1760
37		Core
38	Core	125044 SRO .172 Oak Core/No Acclimation	2632	5208	10304	4760
39	Core	125094 Poplar .172	150	725	875	300
40	Core	125144 Gum/No Acclimation	173017	840595	259754	229821
41	Core	125141 Gum 50.75/No Acclimation	480545	237745	231925	196115
42	Core	125094 Poplar .172 /No Acclimation	8184	16895	7936	10602
43	Core	125104 Gum .172/No Acclimation	0	0	0	0
44	Core	125290 Gum 46W X 48W	44792	54824	50886	65494
45	Core	125051 Poplar core 48W X 46W	44792	54824	50886	65494
46	Core	125094 Poplar .172/No Acclimation	92507.5	71355	82047.5	76652.5
47	Core	125148 SRO Back Dry core/No Acclimation	0	0	0	1760
48	Core	125016 Misc. Cross Bands .177/No Acclimation	8271	6860	1440	13424
49	Core	125008 Oak Back & Dry Core .125/No Acclimation	160	1350	16	0
50	Core	125290 Gum 46W X 48W	44792	54824	50886	65494
51		Crossband
52	Crossband	125103 Gum/No Acclimation	24304	38444	40712	28840
53	Crossband	125144 Gum	148713	802151	219042	200981
54	Crossband	125141 Gum 50.75	480545	237745	231925	196115
55	Crossband	125016 Misc. Cross Bands .177/No Acclimation	8271	6860	1440	13424
56	Crossband	125008 Oak Back & Dry Core .125/No Acclimation	160	1350	16	0
Inventory Calc

So I would like the group to be:

Rows 3 to 28 all data below the blank cell in column 3 to the next blank cell in column 3 (All rows under Face in column 2 then all rows under Back in column 2 based off of blanks in column 3. I have the following cose which is not working properly:

Sub GroupData()'Groups the Type of Veener based on blanks in the new inserted row
Dim i As Integer, LastRow As Integer


LastRow = Cells(Rows.Count, 3).End(xlUp).Row


For i = 3 To LastRow
    If Cells(i, 3) = "" Then
        Cells(i, 3).EntireRow.Group
    End If


Next i
End Sub

The end result would look like this when collapsed:

Excel 2010
	A	B	C	D	E	F
1		Veneer SKU	07/25/2011	08/01/2011	08/08/2011	08/15/2011
2		Face
29		Back
37		Core
51		Crossband
Inventory Calc

Any help would be much appreciated.

 

[mrmmickle1]

I have been working on other projects but, this problem has reared its ugly head again.

This is Cross Posted on the Excel Fox Forum: http://www.excelfox.com/forum/f2/grouping-data-problem-565/

Any help provided would be great. I will post the answer to the inquiry on both threads if I am lucky enought to recieve a response. Thank you all for your time.

 

[mrmmickle1]

This problem has been solved by ExcelFox Rick Rothstein. Thanks so much for your help.

The solution can be found at the below link:
Group Pivot Data Based On Row Values In One Column