How can I swap all the table data in column #5 so it replaces col
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?
|