Copying every nth value from cell and posting into a vertical column

[legolas97]

Hi, I've tried using the index function and the offset function without much success.

I'm trying to copy cell value of L4, P4, T4, X4, etc all the way up to EB4 and paste it in a vertical column using a formula.
I need to do this again for L5, P5, T5, X5, etc.

I've done it manually for now, but I want to create a template so that I don't have to repeatedly perform this task.

Please find the pictures attached and help me out!

In the picture above I want to get every highlighted value out and get it out in a column like I have done manually in this example ^

 

[Joe4]

Place this formula in cell C5 and copy down:

=OFFSET($A$1,0,(ROW()-5)*4,1,1)

 

[KRice]

Here's another idea...sounds as if you want to consider only certain columns and then transpose them:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Jan				Feb				Mar				Apr				May
2	5221	10	11	12	5221	13	14	15	5221	16	17	18	5221	19	20	21	5221
3	1				2				3				4				5
4	a				b				c				d				e
5	u				v				w				x				y
6
7
8	Jan	5221	1	a	u
9	Feb	5221	2	b	v
10	Mar	5221	3	c	w
11	Apr	5221	4	d	x
12	May	5221	5	e	y
Sheet1

Cell Formulas
Range	Formula
A8:E12	A8	=TRANSPOSE(FILTER(A1:Q5,MOD(COLUMN(A1:Q1)-1,4)=0))
Dynamic array formulas.