hi community

in Excel we can paste a copied of data in a transpose manner by using the
Paste Special dialog box, that is, from a Vertical column into a Horizontal
row and vice versa,

is there a way for me to Paste a copied data in a reverse order,

example:

if say, I have a data written as 1, 2, 3, 4, 5
and
wanted to paste in reverse order...5, 4, 3, 2, 1
can I do it in reverse order ?

thanks community for the help and info

--
oldLearner57