excell

[cretesupplies]

hello my dearest developers,

I encounterd the following problem...
Supposing that i a row full of data inevery cell Microsoft excell and all
rows are full.
I'd like now to "transpose" the row into column while inserting the data
without overwriting the existing data.
I'm waiting for ur precious help.

[Max]

One way ..

Assuming source data is Sheet1,
with entire rows filled from row1 to a max of row256
(btw 256 rows deep is the max possible for transposing
to columns as there's only 256 columns per sheet!)

In a new Sheet2
Put in A1: =OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1)
Copy down to A256, fill across to IV256

Sheet2 will return a dynamic transpose of Sheet1's A1:IV256

And if necessary, for a cleaner look,
suppress extraneous zeros from display via:
Click Tools > Options > View tab > Uncheck "Zero values" > OK
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"cretesupplies" <cretesupplies@discussions.microsoft.com> wrote in message
news:25FED381-D8B6-4238-A1ED-F48841DAE95D@microsoft.com...
> hello my dearest developers,
>
> I encounterd the following problem...
> Supposing that i a row full of data inevery cell Microsoft excell and all
> rows are full.
> I'd like now to "transpose" the row into column while inserting the data
> without overwriting the existing data.
> I'm waiting for ur precious help.