Does anyone know of a macro for transposing row data into columns?

Answer by  trigonometry (668)

You do not even need a macro, there is a function. It is called transpose and you can find it in the category Array-functions.

Answer by  technogeek (6640)

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.

Answer by  fredmcsheep (51)

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.