No problem, follow these steps:
1) Create a new blank sheet
2) Go to the source sheet
3) Select the block you wish to transpose
4) Edit|Copy
5) Select the new blank sheet
6) Select Cell A1
7) Edit|Paste Special
8) Click the transpose checkbox
9) OK
This will copy your data into a new sheet with columns and rows transposed.
Josef Lowder wrote:
> Is there any way to change a horizontal oocalc spreadsheet
> to a vertical layout -- i.e. so that all existing horizontal columns
> would be converted to become vertical rows, and all data
> in each column and row is rearranged accordingly?
>
>
>
> ------------------------------------------------------------------------
>
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
(text/plain)
