Organising complicated multiple column data into row data

[Wei_Ji_Kwok]

Hi, im not able to do that,

I need to move multiple email column with the marks given for the email into one row (each email column have unique name) just like image i show.