close
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
quot;nastechquot; wrote
gt; Is there a way to copy a range of columns,
gt; and paste values to the right 1 position to rotate values out...
gt; 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 gt; check quot;Transposequot; gt; 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
savefile.com/projects/236895
xdemechanik
---
全站熱搜
留言列表
