Excel, some versions at least, do have a built in tranpose option in the paste special dialog box, so you don't need a script for that one.