Reverse columns order in libre office calc

Question

Suppose I have This This Cells:

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

any help will be appreciated!

Answer 1

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