Transpose data

[graiggoriz]

Hello,

I have a report that generate players per groups. I would need to copy and transpose the data but I do not know how to archive that!! Formulas, Macro?

I tried with the vlookup formula but I really do not manage to have the data sorted as per the attached document (at least automatically).

Would you think a macro could help? Please refer the attach document (the worksheet "report" is the data I need to copy and paste in the "sort" workbook. I use transpose paste to get the desired result)..

Thansk,
Graig