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 <[email protected]>
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: [email protected]
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
