Copy Data from Sheet1 to Sheet2 then transpose

Hi All,
I have faced a big problem. I have huge data with name, address, email. I want to copy data between 2 email address to sheet2 & transpose.

For example: Please see attached.abc.png

One way

Please Login or Register  to view this content.

Hi @jindon

Thanks a lot. Its' work exactly what i want.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.