How reverse the order of columns?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have made a table with orientation from right to left.
Now I want to change the direction, in other words I want to reverse the
direction of table.
Is there an easy way to do this job.
Copy/special paste/ transpose doesn't work in this case.
 
Think you could use a helper row, then select the range and do the Data >
Sort > Options > Sort left to right under "Orientation".

Eg Insert a new row1, fill the numbers: 1,2,3... across your cols range.
Then select the cols range, click Data > Sort > Options. Check "Sort left to
right" under "Orientation" > OK. Then in the Sort dialog, Sort by Row1 >
Descending > OK
 
Select a column then, r-click and pick Cut, and then select destination
column, r-click select Insert Cut Cells.
 
Back
Top