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
Bookmarks