Search code examples
libreoffice-calc

Reverse columns order in libre office calc

Suppose I have This This Cells:

Initial Enteries

And then for some reason I want to reverse the order of columns automatically to become something like This:

enter image description here

any help will be appreciated!

Solution

  • quick steps:

    • insert new row above 1
    • fill row with monoton increasing integer index to the right.
    • Then select your data and sort descending, so highest indexed right col is first
    • copy and paste the result


    https://gr-plus.blogspot.com/2015/01/reverse-column-or-row-order-in-excel-or.html