Split table - By groups  
 

Use Split field by groups to split a database in multiple data groups, according to repeated values in the selected field.
For example: Say your database is the selected area and the selected field is Category. Click OK.

Notice that several sheets with the expected results have been created.
This tool is very simple to use, but very helpful.