I want to invert a selection in a column before pasting it.
For eg: I have a whole lot of info from Row A1:A45
When I paste it into column B, I want it to flip; i.e.: the selection to
inverthat is, the contents of cell A45 to go into B1, A44 to go into B2 and
so on till I get A1 in B45.
I need to do this a number of times so would rather not do a concatenate
with numbered rows, sort ascendng/sort descending and un-concatenate agian...
is there something you have seen that could help?
I don know if this can be done but over the past week I wonder why it has
not been provided for and I wonder why there is help topic so I can figure
this out on my own.