This happens all the time; you get a set of data and you realize that whatever category is there, is wrong. If it’s regions, there should be 5 regions instead of 8. If it’s product categories, there’s supposed to be a different grouping. And of course there’s 10,000 rows of data that need changing.
Here’s a video showing how to re-categorize the data quickly and easily. It uses a few formulas, and we have videos showing those in detail. Do you have another method you’d use? Share in the comments…
Here is the Windows Media version