Fliping the values in columns

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

Guest

Hi

I have values in columns A to ...say G.
I want to quickly (without retyping the values) flip the order so that what
is now in column A appears in column G, what is now in B appear in F etc.
How can this be done quickly please?

thanks
 
Insert a new row on top, put 1 in A1, 2 in B2 and so to G1, select all
values plus the newly inserted values in A1:G1, do data>sort, click options
and select left to right, sort by row 1 and choose descending
 
The quickest, non-programmatic way to accomplish this is to place sequential
numbers below your values and sort descending. You can also accomplish this
programmatically.
 
Back
Top