How To Flip your Data Upside Down in Open Office

in open •  5 years ago  (edited)

Ever copied a tabel of data into OpenOffice Calc and did not find an easy way to change the order of the data in the tabel?

Here's a simple trick that works fast:

Re: How to flip vertically a column of data in Calc
Postby jackrcook » Mon Dec 21, 2015 5:02 am

  • A very simple way to to this is to insert a temporary helper column. Put numbers in the temporary column starting with 1 down to whatever you need. Then sort the entire data range including the helper column by reversing the sort order of the helper column from largest to smallest. The adjacent column (or columns) are now in reverse order as desired. Lastly, you can delete the helper column.

https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=80932

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

Congratulations @pagandance! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :

You published a post every day of the week

You can view your badges on your Steem Board and compare to others on the Steem Ranking
If you no longer want to receive notifications, reply to this comment with the word STOP

To support your work, I also upvoted your post!

Do not miss the last post from @steemitboard:

New japanese speaking community Steem Meetup badge
Vote for @Steemitboard as a witness to get one more award and increased upvotes!