Sorting an inventory report by similar items
Is there a way to run an item listing report and sort it by similar items? Such as grouping all thermostats together, all wire together, all TVs together, all speakers together, etc.? For context, I am trying to clean up years worth of people at my company not using correct items on invoices, thus giving me a completely inaccurate inventory count on most of our items. I would like to group similar items together so I can get some information based on our inventory counts. All of our purchase orders are correct after having worked on that for the past few months. If I can take a look at, say thermostats, and I see that we have 10 of one kind in stock, but -3 of another and -7 on another, that will give me a good idea of what I need to change on the corresponding invoices.