copy ???
With your data in A1:CR64 in Sheet1, put this in A1 in
another sheet and drag down:
=OFFSET(Sheet1!$A$1,INT(ROW()/97),MOD(ROW()-1,96),)
Or, more generally, use:
=OFFSET(INDIRECT(MID(CELL("address",rng),FIND("]",CELL
("address",rng))+1,99)),INT(ROW()/97),MOD(ROW()-1,96),)
where "rng" = your range, 96 col x 64 rows.
HTH
Jason
Atlanta, GA
-----Original Message-----
HI
I have a 64 X 96 field with data and want to bring the
96 columns in one
column so that column Nr1s 64 entries are followed by
column Nr2s entries. Is
that possible from another worksheet, too?
Thanks
ANDY
.
|