Have put data in columns in OPenOffice org 3.3 Spreadsheet.
Is there a way to reverse the order of the columns which are in date order.
I do not want to have to re-type the data.
Many thanks for any help
I am not an expert in open office but in Excel and Libre it is possible to use data sort to re-arrange the columns. In the menus look for data>sort usually by default this will sort my rows. You may find an options tab that will allow you select "sort by columns".
In Excel, first I make a copy of sheet (so that I always have the original safe) then on the sheet I want to rearrange I insert a blank column then select a column and drag/move it across and plonk it in the blank column I created.
But if you want to re-arrange data that is in a series of dates, which is what I understood the op wanted, surely that could be massively time consuming. Surely it is much easier to go data>sort>options and select "sort left to right"?