Dear sir,

i have a data mentioned below:

Designation     Basic      HRA        DA           Total      Name  ……………..
Engg.                  25000     5000       3000        33000     Amit
Engg.                  30000     7000       4000        41000     Ajay
Driver                  5000      2000       1500          8500    Karan
Operator            10000      4000       3000        17000    Jitender
fieldboy               7000       3000       2500       12500     Anil

& now i want to arrange above mentioned data in following sequence

Name     Designation     Basic      DA       HRA       Total    

Is there any other formula (function) to arrange data in desirable sequence without colomn movement ?

Urgent Help please..

---

Reply from Richard Rost:

I would just set up a set of columns to mirror these ones. So you're using A thru F right now. Just set up H thru M like this:

=F1  =A1  =B1  =D1  =C1  =E1

Then once you have that set up, AutoFill down, and you can copy/PASTE VALUES the data to another sheet if you want.