Reversing row/column in a paste

[jungix]

hi,

I'm trying to paste a selection, but I need to past it horizontally instead of vertically: for instance to copy the selection A1:A10 in A1:J1. Is that possible within a PasteSpecial?

Jungix

[OBP]

Yes, Paste Special - Transpose.

[JKwan]

Do a PasteSpecial - check the Transpose check box.

[jungix]

Thanks