Google Sheets but also working in excel

[N0t Y0urs]

I want to know if you can have a formula that returns a value or moves on till it finds a value in Google Sheets however I think it will be a little more complicated than that as I want to exclude all info that it has previously returned.

I have included an small example of what I am trying to achieve

So this is a small sample of random numbers. If you start at Column C every 2nd row has a value that value is used to populate the net data set. What I would like to achieve is a formula that reads column C to fill Column L and then I will use the same formula for Column I to fill Column R etc. While this example is smallish my data set has 20 different Data Sets then a totalling set and approximately 1000 rows. I have used every 2nd row but mine is every 5 rows.

Any assistance would be great.

Book1
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1	Group 1						Group 2						Group 3						Group 4
2	B	C	D	E	F		H	I	J	K	L		N	O	P	Q	R		T	U	V	W	X
3	1	50					1						1						1
4	2				200		2						2						2
5	3	75	100	100	725		3				75		3						3
6	4				3625		4				375		4						4
7	5	125	1000	2500	14500		5	100	125	500	1150		5				125		5				100
8	6				72500		6				5750		6				625		6				500
9	7	200	10000	125000	227300		7	250	5000	7500	16000		7	375	125	500	2125		7	500	125	500	1375
10	8				1136500		8				80000		8				10625		8				6875
11	9	380	250000	250000	1772620		9	500	50000	50000	59500		9	500	5000	7500	8250		9	1250	1000	2500	9000
12	10				3545240		10				119000		10				16500		10				18000
13	11	525	250000	1250000	5589955		11	750	50000	50000	137250		11	825	5000	5000	22175		11	2500	5000	5000	23500
14	12				11179910		12				274500		12				44350		12				47000
15	13	700	250000	1250000	20859120		13	1500	50000	100000	397500		13	1350	5000	12500	69850		13	7500	5000	12500	69000
16	14				41718240		14				795000		14				139700		14				138000
17	15	1000	250000	1250000	81935480		15	3000	50000	250000	1287000		15	5000	25000	50000	199400		15	10000	25000	50000	191000
18
19
Sheet1

Cell Formulas
Range	Formula
L5	L5	=C5
R7,X7	R7	=C7

 

[N0t Y0urs]

Want to bump this back up for some assistance if it is possible to do.