At 21:54 20/10/2013 +0200, Uwe Brauer wrote:
I googled a bit but found no solution to the problem of rotating a
table such that
| 1 | 2 | 3 |
| 4 | 3 | 4 |
becomes
| 4 | 1 |
| 3 | 2 |
| 4 | 3 |
Do you mean a table in a text (Writer) document?
o Copy the table.
o Paste into a spreadsheet (Calc) document, but using Paste
Special... | Formatted text [RTF].
o Copy the table in the spreadsheet.
o Paste elsewhere in the spreadsheet, but using Paste Special... |
Options | Transpose. (This is the trick, of course.)
o Cut and paste the first column of your transposed table to the
right of your second.
o Copy the new table and paste back into your text document, but
using Paste Special... | Formatted text [RTF].
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]