I have a list of account numbers, in order, that might have 2-3 of the same account number in the rows below it based on a column that has a different value in it. I need to copy and paste that different value to the first row that account number appeared, in the next available column in that row, then move to the next new account number and repeat. Appreciate any help.

Thanks