Offset data from every other column into a single column

[blimes]

	A	B	C	D	E	F	G	H	I
1			25	L	40	R	85	u	67
2
3	25
4	40
5	85
6	67
7
8
9

 

[blimes]

Accidentally posted without asking the question looking to take the data in row 2 starting at C and take every other row and put into a column by using a formula.

Thanks

 

[Peter_SSs]

Like this?

24 10 26.xlsm
	A	B	C	D	E	F	G	H	I
1			25	L	40	R	85	u	67
2
3	25
4	40
5	85
6	67
Column

Cell Formulas
Range	Formula
A3:A6	A3	=INDEX(C$1:I$1,ROWS(A$3:A3)*2-1)

BTW, I have edited your thread title. Please review #14 of the Forum Rules and remember for the future.

 

[blimes]

Perfect thank you very much

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.