How To Flip your Data Upside Down in Open Office

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.