Move goal times to specific cells

[Consty1]

In the attached worksheet I have a sample of football score raw data. The data has the names of the home and away sides as well as the goal time and scorer of the goals in the match. What I'm trying to achieve is for the times of each goal to be placed into specific cells alongside the team name and score. I've used an example at the top of the sheet to show the layout I'm looking for. I guess what I'm ideally after is to copy all the raw data into a sheet and use a macro to transfer the goal times for each match. Not sure if this is possible but it's worth a shot.

Thanks in advance for any replies.

Sample 13.xlsx

[watersev]

hi Consty1, option, press Run button

[Consty1]

Hi, that's brilliant thank you. There's another related issue you may be able to help me with. The raw data I use actually displays the score for each side as a ratio and I usually have to change it manually which can be tedious for a large group of matches. However the 2nd digit of each side of the ratio represents the score for each side so I'm thinking it may be possible to move them into specific cells.

I've attached an example sheet with a description of what I'm looking for.

Sample 13(3).xlsm

[watersev]

if I understood your sample file correctly it might be done this way

[Consty1]

Thank you, that's just what I was after. Really appreciate you taking the time to have a look at it.