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, than 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 are 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.

1 people reacted on this

Comments are closed.