Dynamic sorting - keepting data integrity problem

All,

I have an extremely large excel sheet which has variety of columns of data. I've included an 'example' diagram, although this is not the data, this clearly represents my problem on a smaller scale.

Column 1 is the original third party data, column 2 SHOULD match column 1 but it doesn't. Keeping in mind Column 2 data is mapped to Column 3 & 4 so if we sort column 2 then column 3 & 4 must sort with it.

Hopefully the diagram attached supports the question.

Look forward to the response (note the actualy sheet is around 30,000 lines of data)

Thanks

Wahid

-----------

Added excel sheet - sheet 1 is the problem, and sheet 2 the solution, I hope this is enough to understand the problem.
I believe this maybe require a macro to solve

1 dont post images for workbook problems like this attach a sheet with your before and after requirements (with as realistic as possible data)
2. those images are the same so what conclusion could be drawn from them?

sorry but i cant see what you want from that cols a and b seem just to be matching each other. a1=b1 a2=b2 a3=b3, so why do you need col a?
i think you are over simplyfying something