how to list names in a column in excel in a row

To take names listed in a column in Excel and paste them in a row, you can use the Transpose feature. Here’s how to do it:

1. Select the Column: Highlight the cells in the column that contain the names you want to move.
2. Copy the Data: Right-click on the selected cells and choose Copy or press Ctrl + C.
3. Select the Destination: Click on the cell where you want to start pasting the names in a row.
4. Paste with Transpose: Right-click on the destination cell, go to the Paste Options, and select Transpose (this option may appear as an icon with two arrows). Alternatively, you can use the Paste Special feature by right-clicking, selecting Paste Special, and then checking the Transpose box before clicking OK.

This will convert the names from a vertical list into a horizontal row.

References:

• Excel for the web

Hi @Young, Kevin P,

Thank you for posting your question in the Microsoft Q&A forum.

Based on your sharing, you can try follow the guide provided by Q&A Assist that to use Copy and Paste special feature in Excel to transpose the name list.

If you want to use formula in case the name range is long, you can use the TRANSPOSE formula in Excel: =TRANSPOSE(A2:B10)

Note: this formula is used on my testing worksheet, so you will need to change the data range based on your current worksheet to ensure the formula works properly.

Hope this information proves helpful. You can try this formula and let me know if it works for you. If not, we can work together to find a solution.

Thank you for your understanding and cooperation. If you have any questions or need further assistance, please feel free to share them in the comments so I can continue to support you.

I'm looking forward to your reply.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".      

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Hi,

You may also use the TOROW() or TRANSPOSE() functions.