Change paste direction Calc?

[appreciatethehelp]

Say I’ve copied some characters from four, horizontally adjacent cells i.e. 1, 2, 3 & 4.
If I copy them like this: 1 2 3 4
How do/can I paste them like this, (other than pasting each character individually into the correct position)?
1
2
3
4

Thanks.

EDIT: now that I know that Transpose via Paste Special will allow the orientation to be changed between top-to-bottom/left-to-right, can anyone weigh in on how the direction of the characters can be changed e.g. horizontal left-to-right characters 1, 2, & 3, each in it’s own cell, copy-pasted as 3, 2, 1…?

[robleyd]

Into what are you wanting to paste them? I gather you want them pasted one under the other, although the formatting of your question doesn’t correctly show this.

[appreciatethehelp]

@ robleyd Into sundry other cells in the same Calc document; your answer did the question justice.

[robleyd]

For changing the order, I suspect the simple solution is Sort; once pasted, the cells are highlighted and it is a simple matter of one click on the relevant Sort icon.

[appreciatethehelp]

That would be my go-to as well, just wondered if there was an option inherent in the paste section.
Would make a handy addition, no doubt.

[robleyd]

Did you see an option there? I don’t.

[robleyd]

If you want to paste in a Calc sheet, use Ctrl+Shift+V and select Transpose. I found that with a few moments of fiddling with Paste Special.

If this answer helped you, please accept it by clicking the check mark to the left and, karma permitting, upvote it. That will help other people with the same question.

[appreciatethehelp]

Using Transpose through Paste Special does indeed work, however transpose only toggles paste direction between left-to-right and top-to-bottom, which makes me wonder: is it possible to paste in reverse order e.g. copy paste 123 as 321? I can’t seem to achieve that using Transpose alone…
Will leave question open, in order to discourse on this.