move cellnumber one up if you copy cells to the right

[keis386]

I have a short question if you have a column with numbers and you want to copy them in to a row (not all in once I know that you can do that with copy transpose) But one by one

Rather without a macro but if that is not possible than macro is also fine

[TMS]

Cell F3: =INDEX($C$3:$C$78,COLUMN(F$3)-5)

copy across

Regards