I have a sheet that contains data like this:
Please Login or Register  to view this content.
I would like to be able to condense it(eliminate empty cells to the left) and then somehow sort it smallest to largest based on the cell that contains the store number so that it would look something like this.

Descriptions:
The 0000A number is a store number
The ten digit number is a PO number
The RTD4, TTD3, SM6.... are Part numbers, and the number in the cell to the right of them is Quantity.


Please Login or Register  to view this content.
Any help is appreciated.

Thank you