Applying Regular Expressions to Sort Items in Google Sheets

Lists are more useful when grouped. When you need to analyze a large list of items, you need to create areas of commonality to enable grouping and sorting that list. A simple example of grouping might be to think about a grocery list, where certain items (bananas, oranges) are fruits and other items (paper plates,…