Copying Customer Details Onto Each Sale Line Until Next Customer is Reached

Hi
Hoping this is not going to be too difficult. Have tried to Google the question but not actually sure what I am asking for lol.

I have a huge report which has been sent to us by one of our distributors, which has been formatted by whichever reporting software they use.

I am able to edit the report to give me all the information I need using a macro but need one last bit.

In a nutshell, I need the Account Ref and Name to be copied down as a new column for each Stock Code item underneath it until it gets to the next Account Ref. Once copied I would like to remove the original Account Ref and Name cells to leave a standard Excel spreadsheet that can be uploaded to another system.

I have attached a sample sheet of dummy data (minus a few columns at the end) which should illustrate my problem.

Any help would be greatly appreciated.

Thank you