Thanks Joseph. It worked perfectly! Saved me a tremendous amount of time. Joe
On 6/7/08, Joseph Sinclair <[EMAIL PROTECTED]> 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 - [email protected] To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
