This video explains how you can download a list of students with the groups that they are members of in Moodle. It also explains how you can use find and replace to remove any groups that you don't need (such as assessment groups).