![]() |
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? |
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? |
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? |
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