Laying data out find the first value then the second etc.

I am trying to organize some data the way I want it. I am running into some issues. I thank you in advance for any help.

While its hard to explain in writing I think posting a workbook with some instructions will help.


In column c labelled VIS ( in red) You will see a team name . I am trying to organize a series of boxscores that match the vis&ptsscrd. When a boxscore matches vis&ptsscrd I want to move that data and the 11 columns to the right of the match over to visitors section columns de:dx ( yellow section) . Then If there is another match continue to do the same . Then when that is complete move to the home&ptsscrd.

I have provided a example column that I think explains this a little better.


Thank you so much for any help