excell
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 -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "cretesupplies" wrote in message ... 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. |
All times are GMT +1. The time now is 10:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com