Assume data in A1 down
In B1:
=OFFSET($A$1,ROWS($1:1)*100-100+COLUMNS($A:A)-1,)
Copy B1 across by 100 cols to CW1, fill down by 200 rows to CW200
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Magnus" wrote:
I wonder if it is possible to move data from one column with about 20.000
rows into 100 new columns with 200 rows in each column? Of course I can
always use copy/paste/paste special but is there a quicker way?