At 08:33 07/12/2016 -0700, Nobody Noname wrote:
I would have the need to reverse the content, text above and chords under
<http://nabble.documentfoundation.org/file/n4202044/sapore_prova.jpg>
Here's one way:
In B1 (or wherever), enter:
=OFFSET(A1;MOD(ROW();2)*2-1;0)
and fill it down the column.
Note that this works if your list starts in an odd-numbered row (as
it does in your picture - in row 1), so that you are exchanging the
contents of an odd-numbered row with those of the even-numbered row
following it. If your list started in an even-numbered row, so that
you were instead exchanging each odd-numbered row with the
even-numbered row preceding it, you would need to use the similar formula:
=OFFSET(A1;1-MOD(ROW();2)*2;0)
instead. Alternatively, you could use the original formula but
displaced by one row from the data.
I trust this helps.
Brian Barker
--
To unsubscribe 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
