You can use the "transpose" command in the Paste Menu/PasteSpecial Menu. It still involves a little work on your part, but reduces the cutting and pasting required.

I am assuming that all the records are in column A. So

1. Select the 1st record & click copy.
2. Select B1
3. Select the dropdown arrow by Paste->Transpose

If you're feeling really brave, make your selection (FIRST!) and then try recording a macro to do the donkey work for you. You can attach the macro to a button/shortcut command etc.