[plug] openoffice calc question

[Senectus .]

brilliant thanks, I knew it was something simple :-)

On 11/21/05, Alex Polglaze <apolglaze at book-keepingnetwork.com.au> wrote:
> Senectus . wrote:
> > How do you turn a row of cells with data in them into a column of cells ?
> Rotating Tables (Transposing)
>
> In OpenOffice.org Calc, there is a way to "rotate" a spreadsheet so that rows become
> columns and columns become rows.
> 1.Select the cell range that you want to transpose.
> 2.Choose Edit - Cut.
> 3.Click the cell that is to be the top left cell in the result.
> 4.Choose Edit - Paste Special.
> 5.In the dialogue, mark Paste all and Transpose.
> If you now click OK the columns and rows are transposed.
>
>
>
> Alex Polglaze
> _______________________________________________
> PLUG discussion list: plug at plug.org.au
> http://www.plug.org.au/mailman/listinfo/plug
> Committee e-mail: committee at plug.linux.org.au
>


--
Ubuntu Breezy 5.10
CNet News.com: So that would be the philosophical difference between
Microsoft and what Google is up to at this point?
Bill Gates: Well, we don't know everything they are up to, but we do
know their slogan and we disagree with that.
www.modmeup.net