Hi
try the following formula:
=OFFSET('sheet1'!$A$3,COLUMN(A:A)-1,0)
and copy this to the right

"Joe the Toe" wrote:

Hello,

Can anyone help me?
I have a column of numbers as follows:
1
2
3
Using copy/paste special transpose i can put them into a row but only as
follows: 1,2,3
Does anyone know a quick way to put them in this order:3,2,1

Cheers

Joe