excell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top