Is there a way to change an oocalc horizontal layout to vertical?

[Josef Lowder]

Thanks Joseph.  It worked perfectly!
Saved me a tremendous amount of time.

Joe

On 6/7/08, Joseph Sinclair <plug-discussion at stcaz.net> wrote:
>
> 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?
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.PLUG.phoenix.az.us/pipermail/plug-discuss/attachments/20080608/b0dc8000/attachment.htm