Is there a way I could change the column order say there are 6 column, I want the 6th column to be in 2nd order and the previous column 3,4,5 become 4,5,6 automatically.

I have tried to change column order of the 6th to be in 2nd but the previous 2nd become 6th.

Appreciate help.

Thanks

Ed