Add Paste - Invert option
Provide and option to "Invert" the data when pasting in addition to the Transpose option.
I like the idea of an invert, but the transpose option should also be able to paste over existing data. If I copy A1:A20, and try to paste (transposed) into A1:T1 it fails and I have to go into B1:U1 and then delete column A. I suspect an invert would have this same problem.
For Kenneth...I a not sure what "transpose" means either, since one could go clockwise or counter-clockwise, except by learning through experience.
Kenneth Barber commented
What does "invert the data" mean on say, a range like the one below (2 rows, 2 columns)?