Count items based on a specific column value and update a second list
I have a SharePoint list with all the users that have requested an Account. When adding a new item, a user needs to fill in his name, and his group. Currently, my list has 100+ entries and I would like to create a workflow, that counts how many users are in each group, and those value would be used to fill in a column in another list.
Basically, the 2nd list is just a copy of the first one, but it only has 2 columns: the GROUP NAMES and NUMBER OF MEMBERS of each group. This 2nd list needs to be updated automatically based on the first list.