Hello,
I can prepare an Excel VBA macro to do the job. It will be very efficient and easy to use, auto detecting last row of data (and column if needed). I will gladly take look at the file to have a complete idea of what needs to be done.
By the way I strongly recommend tagging such projects as Excel in the future, to get more properly qualified freelancers bidding and have them ranked also based on past Excel projects, not on PHP ones, what mainly happens in this case.
Regards