I have a sheet that contains data like this:
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.![]()
Please Login or Register to view this content.
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.
Any help is appreciated.![]()
Please Login or Register to view this content.
Thank you
Bookmarks