Macro for many to one copy and paste

[CAM174]

Hi all,

I'm not sure if I'm even explaining this right.

I have two sheets in a workbook. Sheet1 has about 57000 rows and 32 columns of data. I will not show exactly what my sheets look like because this is for work.

Examples are purposely vague, but here goes:

Col E: Names of people. E.g. Bob.
Col. D: Names of their friends who they partner with for games. Bob has about 10 friends, sometimes he likes to play with Jane or Bill, and the games vary.
Col M: Games listed.

Based on the specific game, and the key player and their partner, I need to populate Sheet2, so if Bob(Col E) is listed with 5 games(Col M), and 8 partners(Col D), will be listed 8 times, or 5 times, whichever is more.

Can this be done with Macros?

Please help me, thank you. If you need it explained differently, just ask.

Thank you!

 

[CAM174]

So, over 41k unique people, with like 50 or so different games to choose from.