Copy, paste, transpose 4 cells delete and repeat

I can't tell you how grateful I am for the help. You have gone above and beyond and saved me probably fifty hours of copying and pasting. I don't know how I can possibly thank you. You've gone above and beyond and I thank you from the bottom of my heart! The solution works flawlessly!