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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with column accumulation needed 2
How can I create a table w/ 5 cols. & 2/rows, then sort col 5 to 1
Macro for comparing columns and highlighting matching/differences 13
modified pivot table using a macro 2
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Resize a row but copy but skip columns I don't want to copy 6
Changing column reference for number of formulas at once 1
concatenate entries from a column into a cell by logical AND withanother column 2

Top