Need Help Aligning PlayerStats/GoalkeeperStats to Match Sample Format

Hi all,

I’m working on a project where I’m tracking MLS soccer stats in Excel and trying to structure the data in a clean and consistent way. I’ve attached two files:

MLS Hub - Copy.xlsx — this contains all the match data across sheets like Matches, PlayerStats, and GoalkeeperStats.

Player Stats Example.xlsx — this is the format I’m trying to achieve for my final PlayerStats sheet.

Here’s what I’m trying to do:

Copy player names with hyperlinks
In the PlayerStats sheet, I want to copy the names from Column A into Column X, keeping their hyperlinks intact. These names are located between the rows labeled “Player” and “Players” (start and end of the player table per game). Some rows may be blank or have labels like “Game#:” — those should be skipped.

Match game data from the Matches sheet
For each player row, I want to also add data from the Matches sheet:

Season (Column L in Matches)

Date (Column B)

Team they played for (either Column D or G depending on home/away)

H/A — "H" for home, "A" for away

Opponent — whichever team they played against

SID (Column J)

Each player row should reflect this game info based on the order of the teams in the PlayerStats sheet.

Match the layout of Player Stats Example.xlsx
I want the data to follow the structure in my example file, starting from Column X onward.

Right now, the hyperlink copying is inconsistent, and the game data doesn’t always map row by row. I'm not sure if I'm missing a simple trick or if the structure needs adjusting.

If anyone has time to take a look or offer any suggestions, I’d be incredibly grateful. I’ll be out most of the day but will follow up as soon as I can. Sometimes a fresh set of eyes can help a lot.

Thanks in advance for your time and help!

Hi,
did you mean something like this?
Press the "Aligning" button.
m.s.