The following image shows the first few rows of a worksheet that has 500 rows of data.
You would like to rearrange the data so that all the records with the East region appear first, followed by all the records with North, followed by South, followed by West. Within each region, you would like all the records with Plastic to appear first, followed by Metal, followed by Ceramic. The first few rows of the resulting worksheet would look like this:
On the image below, click on the sequence of commands you would use to create the resulting worksheet.