There is a TRANSPOSE function that sounds like it is what you want but I'll
be darned if I can figure out how to get it to work when i was just testing.
Perhaps under Help, do a search for TRANSPOSE function and see if that helps.

"Ed" wrote:

Thanks Tim, but I meant to drag rather than copy-paste special, like when you
put "=" and select a entry from other sheet then drag it downwards and you
get what the other column from the other sheet has, but "transposed" when I
drag horizontally I get what is vertically in other sheet.

The thing is that I need some entries as a row that are as column in other
sheet and I can't just copy-paste special because I have some other formulas
and things that would make it more difficult... sorry for not explaining
correctly on the first post!

I need

Sheet B:
B1 = SheetA!A2
C1 = SheetA!A3
D1 = SheetA!A4
E1 = SheetA!A5

and so on!