Changing the order of columns in the table...what is the best method?

[PP3321]

I have a table with 10 columns.
I want to move:

10th Column ---> the 5th position
2th Column ---> the 8th position

I can cut & insert.
But I am looking for ways to do it automatically.

*I found this forum post.
1 Method is to transpose the table and sort...
http://forum.chandoo.org/threads/sorting-horizontally-in-tables.12211/

I would be grateful if you could give me advice...


What would you recommend that I do to do this?

 

[Naresh Yadav]

Hi,

I think this is possible if you could share your data with your desire result in excel file...

 

[PP3321]

@Naresh Yadav
Thank you for post. Sorry I cannot upload.
But I added the screenshot above to show the desired result.
I would just like to know how you would approach this problem....

 

[Naresh Yadav]

Hi,

you just insert a ROW top to your heading and than sort your data and click on "options"-select "Case Sensitive"-Select "Sort left to right"-Click ok and than sort by ROW 1

 

[Naresh Yadav]

i have shared you an excel as a example where i have place a numerical value
based on your query..

 

[PP3321]

Wow! Thank you so much @Naresh Yadav
I did not know such option existed in Sort.
Thank you!!!!