Populate cells based on criteria

[cjcass]

Hi,
I'm looking for a solution to the following if possible:
Is there a formula I can put into Column G (from G4 down) that will return what you can see in the picture? The formula is populating based on the criteria in Range C4:D8 and putting a blank cell between each animal type. A single formula would be great but I can work with intermediate helper cells/formula if necessary. I can work with a VBA solution if necessary but would like to see if there's a formula solution first (any VBA solution can't add rows).
Any help much appreciated.

 

[cjcass]

How about

Fluff.xlsm
	A	B	C	D	E	F	G
1
2
3
4			Swan	3	0		Swan
5			Goat	5	4		Swan
6			Duck	2	10		Swan
7			Dog	1	13
8			Cat	3	15		Goat
9							Goat
10							Goat
11							Goat
12							Goat
13
14							Duck
15							Duck
16
17							Dog
18
19							Cat
20
21
Summary

Cell Formulas
Range	Formula
E4:E10	E4	=IF(D4="","",SUM(D$3:D3)+ROWS(E$4:E4)-1)
G4:G21	G4	=IF(OR(ISNUMBER(MATCH(ROWS(G$4:G4),$E$4:$E$10,0)),ROWS(G$4:G4)>MAX($E$4:$E$10)+1),"",INDEX($C$4:$C$10,MATCH(ROWS(G$4:G4),$E$4:$E$10,1)))

I've just thought of an added complication which I should have mentioned at the onset but didn't consider it - one of the entries in Col D could be 0 - in which case the animal should be completely ignored in the result

 

[Fluff]

This will handle the 0 values

Fluff.xlsm
	A	B	C	D	E	F	G
1
2
3
4			Swan	3	0		Swan
5			Goat	5	4		Swan
6			Duck	0	10		Swan
7			Dog	1	10
8			Cat	3	12		Goat
9							Goat
10							Goat
11							Goat
12							Goat
13
14							Dog
15
16							Cat
17
18
19
Summary

Cell Formulas
Range	Formula
E4:E10	E4	=IF(D4="","",SUM(D$3:D3)+COUNTIFS(D$3:D3,">0"))
G4:G19	G4	=IF(OR(ISNUMBER(MATCH(ROWS(G$4:G4),$E$4:$E$10,0)),ROWS(G$4:G4)>MAX($E$4:$E$10)+1),"",INDEX($C$4:$C$10,MATCH(ROWS(G$4:G4),$E$4:$E$10,1)))

 

[cjcass]

This will handle the 0 values

Fluff.xlsm
	A	B	C	D	E	F	G
1
2
3
4			Swan	3	0		Swan
5			Goat	5	4		Swan
6			Duck	0	10		Swan
7			Dog	1	10
8			Cat	3	12		Goat
9							Goat
10							Goat
11							Goat
12							Goat
13
14							Dog
15
16							Cat
17
18
19
Summary

Cell Formulas
Range	Formula
E4:E10	E4	=IF(D4="","",SUM(D$3:D3)+COUNTIFS(D$3:D3,">0"))
G4:G19	G4	=IF(OR(ISNUMBER(MATCH(ROWS(G$4:G4),$E$4:$E$10,0)),ROWS(G$4:G4)>MAX($E$4:$E$10)+1),"",INDEX($C$4:$C$10,MATCH(ROWS(G$4:G4),$E$4:$E$10,1)))

That works great, many thanks for the solution

 

[Fluff]

Glad we could help & thanks for the feedback.