copy-move question

[nastech]

Is there a way to copy a range of columns, and paste values to the right 1
position to rotate values out... would be keeping the 1st column intact.
Thanks

[Max]

"nastech" wrote
> Is there a way to copy a range of columns,
> and paste values to the right 1 position to rotate values out...
> would be keeping the 1st column intact.

I'm guessing you want to transpose ...
Tinker along these lines

Assume we have in A1:C4

6 7 2
6 6 4
6 9 5
2 1 8

Copy A1:C4, then right-click on say, E1,
choose Paste special > check "Transpose" > OK
and we'll get it transposed in E1:H3 as

6 6 6 2
7 6 9 1
2 4 5 8
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---