There is no macro. Just copy the information, select the cell where you wish to start the column, and then click Edit, Paste Special. When the paste special dialog box opens, there will be an option in the bottom right of the box that says "transpose". Place a check in the box next to the word and you are done.
There is no need to use a macro if using Excel. Highlight the cells containing the data and copy them. Move the cursor to where you want to paste the transposed data, and select Paste Special from the Edit menu. Click the checkbox marked Transpose and hit OK.