Ensure strings in column B only appear after the same string in column A

Hi.

I have a large spreadsheet (24k rows) of (mostly) clothing products, each product has multiple rows to account for different sizes or colours. This spreadsheet is imported into a database but if it isn't in the correct order the product variations (size-colour) aren't created properly. The attached sample spreadsheet shows how the products are listed using Parent and Child product codes (SKUs). There should be a parent product (with an SKU in column A only) followed directly by any variations (with their own SKU in column A and the SKU of the parent in column B - see example)

How can I sort the spreadsheet so that the variations (children column B) always directly follow the parent product (column A)?

Thanks.

Originally Posted by Richard Buttrey

It's not clear to me which is the original data and what are the results you expect.

Please identify what you start with and manually add the results you expect to see after any sorting has taken place.

Sorry, does this make it clearer? (attachment)

Thanks Richard. I've just tried this on my 'actual' spreadsheet and it seems to have done the trick! I'm going to import to the db now and see if my broken products get fixed :-)

I spoke too soon; it only worked on some of the sheet :-(