Copy formula from every other column

[ajvee]

Hello Excelites, I need to copy information from every other column into a format where it is displayed sequentially. I have tried using the index as well as offset commands and just can't get it to work. Can someone help me out?

Example: information is located in cells C5,C7,C9, etc. I need to put the information in B15,B16,B17, etc.

Many thanks!

 

[shg]

Welcome to the board.

	B​	C​	D​
5​		a
6​
7​		b
8​
9​		c
10​
11​
12​
13​
14​
15​	a		B15: =INDEX(C:C, 2*ROWS(B$15:B15) + 3)
16​	b
17​	c

 

[ajvee]

Thank you...I did not write my example correctly. What I meant to write is this:

Example: information is located in cells C5,E7,G9, etc. I need to put the information in B15,c16,C17, etc. Would I substitute "columns" for "rows" in your response?

 

[shg]

	B​	C​	D​	E​	F​	G​
5​		a
6​
7​				b
8​
9​						c
10​
11​
12​
13​
14​
15​	a					B15: =INDEX($1:$1048576, 2*ROWS(B$15:B15) + 3, 2*ROWS(B$15:B15) + 1)
16​	b
17​	c