How to get subsets by unique values

[TimeTravellerK]

This is fantastic. Thank you @GreyMerchant

Also, you mentioned something about unpacking.

df1 <-- df_list[[1]] gives me a subset for department 'Training'. Is there a way to automatically unlist one by one by their department and save as department.xlsx ?

see this post to get additional details:

Filter by unique category and save as uniqueCategory.xlsx in a folder

I have a dataframe as provided below; ID Department Strength DoD Group_ID 82950 Training 96 953 A 32045 Training 86 5277 A 84817 Sales 77 1633 C 2857 Logistics 88 5629 Z 55587 Training 46 6710 L 73103 Sales 51 1892 M 5837 Sales 62 2394 A 7140 Sales 81 2854 C 70450 Logistics 56 5449 A 34207 Manufacturing 85 1332 S 20095 Manufacturing 58 4589 X 30200 Sales 91 1094 W 47211 Manufacturing 36 5862 C 8932 Manufacturing 75 4847 A 82663 Manufacturing 39 5798 A I do this activity everyday manually filter column category one by one, copy filtered data, open a new .xlsx file, name it by the filtered category name, password protect and save it in a folder. edit: T…