This can be done with Copy and then using Paste Special instead of regular
Paste.

First select the cells on Sheet1 to be copied, then go to the location on
the second sheet where you want them to start and use
Edit | Paste Special
check the box next to [Transpose] and hit the [OK] button. Voila!

If you want to do it with a formula on the second sheet, use something like
this:
=OFFSET(Sheet1!$A$1,COLUMN(A1)-1,0)
That formula would go in cell A1 on the 2nd sheet and presumes your data
starts in cell A1 of Sheet1.

"Deba" wrote:

I have been reading all the advice and tips posted on this group and it
is fantastic!! I now have a query of my own:

I have one sheet where these calculation I am doing go down onto forty
rows say:

Sheet1
A
1 0.1
2 0.4
3 0.8
4 1
5 1.5
6 2
7 4

Than I want to reference that list in another sheet but they should
move along columns so:
A B C D E
F
1 0.1 0.4 0.8 1 1.5 2

So far i tried by writiing

=Sheet1!$A1 and then dragging it along the other columns with the
hope it fills all the others up and changes accordingly. Unfortunatly,
it doesn't change ! If Ii drag it downwards (along rows) it does work
so I assume its not mean to do it but I wonder if there is a way?

Can someone please help with any advice!!!

Thanks

Deba