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?
>
>