How to set the ascending order datas in the desired result?

[PRADEEPB270]

I have a file having 9000 rows with S.No. 1,2,3,4 etc. ,in ascending order.It has downloaded from available system in the company.

Can it be possible the file be in the format of desired sheet ( attach file ) through macro working or excel formulaes which is best suitable for the achieving?

For more clarification,please refer the attach file of download sheet and Desired Sheet.

[newdoverman]

I created a new worksheet and I believe accomplished what you want.

There are helper columns with the text formatted the same colour as the background so that they don't show.

[PRADEEPB270]

Excel formula is working fine.Can it be possible through macro working?If yes,how?

[newdoverman]

Someone who knows VBA would have to do that.

[PRADEEPB270]

Can anybody solve above query through VBA Codes?

Thanks in advance for efforts.