Thanks Joseph. It worked perfectly!
Saved me a tremendous amount of time.
Joe
On 6/7/08, Joseph Sinclair <
plug-discussion@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?
>
>
---------------------------------------------------
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)