How to convert column order?

[mobimus]

Hi,

Is there any way to convert the column order?

For example:

ColumnA;ColumnB;ColumnC;ColumnD;....

How to have like the inverse order:

.....;ColumnD;ColumnC;ColumnB;ColumnA

Nota: If there's any formula, it should be keeped


Thank you very much in advance

 

[Don Guillett]

A bit more explanation might help

 

[mobimus]

A bit more explanation might help
Ok,

You suppose that you have 4 columns in the foloowing order: A(Name);
B(LastName); C(Grade); D(Marks).

Now, I would like to have colmuns in the inverse order, like:
D(Marks); C(Grade); B(LastName);A(Name)

I hope it's more clear now

I'm waiting for your help

 

[Don Guillett]

highlight your columns>data>sort>descending>options>left to right

 

[Dave Peterson]

You could also select the column you want to move and shift-click on one of its
borders. Then drag it to its new position. (let go of the mouse button before
you let go of the shift key.)

 

[Guest]

You cannot change the letter associated with a column. A is by definition the
leftmost column, B the second one from the left, etc. So no, you cannot have
D(Marks); C(Grade); B(LastName);A(Name)
But you rearrange the data that appears in each column, like this:
A(Marks); B(Grade); C(LastName);D(Name)
See DOn Peterson's post for instructions on moving columns around the
worksheet.

 

[Gord Dibben]

To reverse the data order in the columns.........

Assuming 6 columns

Insert a row at top of range.

Enter the numbers 1 to 6 across.

Select the columns then Data>Sort>Options>Sort left to right.

Sort on the row with numbers in Descending order.


Gord Dibben Excel MVP