Hello, if you want to do this copy data and select paste special and select transpose, it change from column to row, let me know if this is not the case.
Also more about me:
I am m.s of systems engineering and b.s of industrial engineering, and excel and vba expert. I have done similar projects and I am confident about my profession, I also accept revisions and removing errors and minor changes in future for free, whenever you are ready lets go. I have good command of English that I think can be useful for this project. I have a base of statistics, mathematics, accounting, cost calculating, project scheduling and project management and finance that helps in this project.