How can I swap all the table data in column #5 so it replaces col

M

me

I have the table below.

I want to select and sort all of column #5 so that it becomes column #1 and
I want column #1's data to appear as column 5. I really want to swap
columns in a sense.

1 2 3 4 E
A B C D 5

Can this be done easily with a sort, rather than a cumbersome copy and paste?
 
S

Suzanne S. Barnhill

Why don't you just drag the columns where you want them to be? But I don't
understand how sorting enters into it.
 
Top