Organising complicated multiple column data into row data

Originally, In each row contain multiple email with the mark given to the email. I hope to convert the way into expected sheet. Expected sheet was the output i hope to see. Any suggestion to solve this problem? Appreciate for your idea