Pasting nth cell into new sheet

[imnion]

Hello!

I'm new here, but I hear you guys are the best for Excel help. I was hoping you could work your magic for me. I've searched around Google, but I can't seem to figure out a solution.

I'm doing research into Jeopardy! and I have a 700 row sheet organized by player, so my info is:
Game / Player / Other Info
1 / Tom / Etc
1 / Sue / Etc
1 / Ann / Etc
2 / Bob / Etc
2 / Jan / Etc
2 / Trevor / Etc

On the second sheet, I'd like to organize by game, so:
Game / Player / Info / Game / Player / Info / Game / Player / Info
1 / Tom / Etc / 1 / Sue / Etc / 1 / Ann / Etc
2 / Bob / Etc / 2 / Jan / Etc / 2 / Trevor / Etc

I tried auto fill, but it won't work. Is there an easy way to do this? Thanks in advance for any help!

[stanleydgromjr]

imnion,

Detach/open workbook imnion - EF757941 - SDG12.xlsm and run macro ReorgData.