ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Possible to "rotate" range of cells so columns are rows and vice versa? (https://www.excelbanter.com/new-users-excel/124887-possible-rotate-range-cells-so-columns-rows-vice-versa.html)

[email protected]

Possible to "rotate" range of cells so columns are rows and vice versa?
 
Is it possible to select a rectangular range of cells and then generate
a copied range of cells that is a rotation of the first range, where
the columns are the rows, and vice versa?


Peo Sjoblom

Possible to "rotate" range of cells so columns are rows and viceversa?
 
Maybe

copy, then paste special and select transpose

Regards,

Peo Sjoblom

wrote:
Is it possible to select a rectangular range of cells and then generate
a copied range of cells that is a rotation of the first range, where
the columns are the rows, and vice versa?


CLR

Possible to "rotate" range of cells so columns are rows and vice v
 

Copy PasteSpecial Transpose.........

Vaya con Dios,
Chuck, CABGx3




" wrote:

Is it possible to select a rectangular range of cells and then generate
a copied range of cells that is a rotation of the first range, where
the columns are the rows, and vice versa?



[email protected]

Possible to "rotate" range of cells so columns are rows and vice versa?
 
Never mind, I discovered "Paste Special" and "Transpose".



All times are GMT +1. The time now is 08:32 AM.

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