Organising the form of output by changing multiple column to row

[Wei_Ji_Kwok]

Right now my data caught was the first image. In each row contain multiple email with the mark given to the email. I hope to convert the way into image 2. Second image was the output i hope to see. Any suggestion to solve this problem? Appreciate for your idea

[avejr748 (Ave Salvante Jr)]

Hi @Wei_Ji_Kwok, this is doable. First create a datatable dtOutput with columns names as Email, Confidence, Deliverered… etc. Then read range your excel in first image to dtInput. For each row in dtInput add a datarow to dtOutput three times.