ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I convert an entire sheet from columns to rows? (https://www.excelbanter.com/excel-worksheet-functions/55089-how-do-i-convert-entire-sheet-columns-rows.html)

dorthy

How do I convert an entire sheet from columns to rows?
 

My dilema, I can transpose section by section, but not the entire sheet.

Is there a way do do tihs?

thanks

R.VENKATARAMAN

How do I convert an entire sheet from columns to rows?
 
is the sheet full all the 65536 rows
in that case the no. of rows is 65536 but no. of columns is 256.
or have I not understood????

"dorthy" wrote in message
...

My dilema, I can transpose section by section, but not the entire sheet.

Is there a way do do tihs?

thanks





All times are GMT +1. The time now is 05:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com