1. While active in your range, Data | Get & Transform | From Table. 2. Select the Name column in Power Query. Transform | Split column on semicolon at each instance 3. Select Group ID column | Transform | Unpivot other columns 4. Remove Attribute column 5. Home | Close and Load 6....