Thread: Getting data from vertical axis to horizontal

Hi all,

I am trying to transfer data from on sheet to another but the problem is that in first sheet data is on the vertical axis while on the second sheet i need to transfer them in horizontal axis.

e.g.
Sheet 1 cells:
a1=1
a2=2
a3=3
a4=4 etc

and i need to enter a formula that i can drag in order for sheet 2 to be like:

a1=sheet1-a1
b1=sheet1-a2
c1=sheet1-a3
d1=sheet1-a4 etc

Is this possible?

Your help is really appreciated!!

Thanks

Try:

=INDEX(Sheet1!$A:$A,COLUMNS($A$1:A$1))

copied across.