I got 2 answers on this but still can't get it to work, one answer was
Transpose and the other was autofill, both don't work the way I want.
I want to copy columns of numbers down ward and paste the upwards.
copy down
Cell 1 = 1
cell 2 = 2
cell 3 = 3

paste so
cell 1 = 3
cell 2 = 2
cell 3 = 3

2nd question, Transpose is to turn around up and down to left to right?

Thanks Bob