Transposing from columns to rows

I need to move the names (col B) to rows assigned to the app group name - I've tried unpivot - I cannot work out how to do it.   For example WP2CCAC - Kasia Barnert and Shelley Attfield on one row...