Generate multiple files based on single column

I need to generate multiple files based on category, say for example, The table having list of columns and category column have multiple values. Category: milk_products water_products oil_p...