One way if you need it dynamic, is via using TRANSPOSE()
Assume source range is in Sheet1, in A1:T5 (a 5R x 20C range)
In Sheet2,
Select A1:E20 (a 20R x 5C converse range)
Put in the formula bar: =TRANSPOSE(Sheet1!A1:T5)
Array-enter the formula by pressing CTRL+SHIFT+ENTER
A1:E20 returns a dynamic transpose of what's in A1:T5 in Sheet1
For a neater look, we could suppress extraneous zeros display via:
Click Tools Options View tab Uncheck "Zero values" OK
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"petergblunden" wrote in message
...
I wish to array dat by switching colums to rows and rows to columns
without
cutting and pasting for ever. Help please.
|