| View previous topic :: View next topic |
| Author |
Message |
comomolo
General User
Joined: 15 Jun 2004
Posts: 45
|
 Posted: Thu Sep 28, 2006 8:51 am Post subject: Swap rows and columns |
 |
|
is there an easy way to select an area of a spreadsheet and swap rows and columns in that area. This is like changing the orientation of the data.
Some people send me tables horizontally layed out and I need them vertically layed out.
TIA |
|
| Back to top |
|
 |
DiGro
Super User
Joined: 02 Jun 2004
Posts: 1208
Location: Hoorn NH, The Netherlands
|
| Posted: Thu Sep 28, 2006 8:55 am Post subject: |
|
|
Copy the range, then Edit > Paste special > Transpose on the spot you want.
_________________
DiGro
Windows 7 Home Premium and OOo 3.3 NL (Dutch) |
|
| Back to top |
|
|
comomolo
General User
Joined: 15 Jun 2004
Posts: 45
|
| Posted: Thu Sep 28, 2006 9:34 am Post subject: |
|
|
Thanks! That was easy  |
|
| Back to top |
|
|
DiGro
Super User
Joined: 02 Jun 2004
Posts: 1208
Location: Hoorn NH, The Netherlands
|
| Posted: Fri Sep 29, 2006 8:24 am Post subject: |
|
|
We aim to please 
_________________
DiGro
Windows 7 Home Premium and OOo 3.3 NL (Dutch) |
|
| Back to top |
|
|
|
