Formula copies auto when we go vertical but what about go vertical and take data from horizontal?

[cadandcode]

Hi, I manage and edit more than 2 different sheets from different files. When we drag cell vertical down, it copies formula and automatically perform process. (like A1=B300, A2=301 and so) But how can I take datas from in horizontal condition to vertical condition? (like A1=B300, A2=C300, A3=D300)
Example;

sheet 1	A	sheet 2	A	B
1	=pinkcar1 (=A1 in sheet 2)	1	=pinkcar1	=pinkcar2
2	=pinkcar3 (=A1 in sheet 2)	2	=pinkcar3
3	=pinkcar2 (=B1 in sheet 2)	3
4		4

 

[James006]

OK....

So let's change the formula in your cell C1:

=OFFSET(INDIRECT("H"&COLUMN()),0,ROW()-1)

and you can copy it down till C8

then, you can select the range C1:C8 ... and drag it to Column D ... to get your result ....

 

[cadandcode]

@Peter_SSs s @shinigamilight @Fluff Sorry for bothering but I need your knowledge, "when you have free time for me", thanks.

 

[cadandcode]

hi

 

[James006]

Hi,

In Sheet 1 cell A1

=OFFSET(Sheet2!$A$1,INT((INT(ROW()-1))/2),MOD(ROW()-1,2))

 

[James006]

???

 

[cadandcode]

???

I am sorry forgetting to reply, that didnt work

 

[James006]

Can you expand on the result you get with the proposed formula ... and more importantly ... Why it is not what you asked for ...

 

[James006]

Is it an issue of adjusting the sequence ....from horizontal to vertical ... with odd and even numbers ...???

 

[James006]

If in your Sheet 2, column A is holding all your Odd Numbers and Column B is made of all the Even Numbers ...

with the objective to reconstruct the ascending order ...

then in Sheet1, cell A1, you can use =OFFSET(Sheet2!$A$1,INT((INT(ROW()-1))/2),MOD(ROW()-1,2))

and copy this formula down in column A to get your results