Fastest way to analyse the data

[aiden1983]

Ok So I want to sort a bunch of data to categorize but I have a lot of them (maybe 100-150 possibilities/categorize) and I have maybe 6000 rows of data. What is the best way to sort it into the categorizes? I know I can use a bunch of if else statements but is there a faster way? Hope you get what I mean here

 

[c_m]

I am not sure of what you exactly want but I'd use pivot table to sort the data into various categories.