Hmm, i see your problem.  Now perhaps someone else may have a simpler way of
doing this - but it can be done simple enough with VBA.  Lets say we have a
column of data in cells A1 to A10 which need to be copied into cell
C2,D2,E2.....

dim x as integer
dim intValue as integer (change this to the data you are working with)

for x = 0 to 9
   intValue = range("A1").offset(x,0).value
   range("C2").offset(0,x).value = intValue
next x

Hope it helps

You can use this formula in A1 (if the starting cell is not A1, you have to
adapt the formula) of the destination sheet an then copy across rows and
columns:

=OFFSET(Foglio1!$C$12,COLUMN(A1)-1,ROW(A1)-1)

the assumption is that data in columns are on Sheet1 starting from C12.

You have to adapt the assumption to your real data.