Re: [libreoffice-users] flip columns in calc

I would think of each column as a "row" of a database. Add a row above the  
db range. Populate it with characters in a sequence which, when sorted in  
ascending order, will put the data columns in your desired order. Use  
"Data | Sort" GUI processes to sort the columns as columns in that  
ascending order.

Transpose converts rows to columns and columns to rows.
--
David S. Crampton

On Wed, 02 Nov 2011 21:12:08 -0700, Jason Paul Joines <jason@joines.org>  
wrote:

>      I'm using LibreOffice 3.4.3 on Kubuntu 11.04.  Is there any way to  
> reverse the order of columns in a Calc spreadsheet?  For example, if I  
> have columns A through Z, I want to re-order them so that the contents  
> of Z are in A, Y in B, X in C, ..., A in Z, B in Y, C in X.  In reality  
> I need to leave the first 9 columns in order and have many more than 26  
> columns.  Is there something that works similarly to transpose in "Paste  
> special..." but to reverse columns instead?
>
>
> Jason
> ===========

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted