Organising complicated multiple column data into row data

[Wei_Ji_Kwok]

First image was how i test and second image show like this but i hope to make every single email in one row