Column to Row

A

ak

Select the data in the column.

Copy the data

Select the cell to begin the row then

Go to Edit - Paste Special - Transpose.
 
A

Andy Brown

With your data in eg: A1:Z1 -

Select it. Copy it. Select A2. Edit >> Paste Special >> Transpose >> OK.

Rgds,
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Cell data entering slow! 0
sqlite-odbc write conflict 2
Copy addition formula of non-consecutive horizontal cells 2
How to center adjust text above and image in a two column document. 1
Finding Duplicate Rows & Highlighting them 6
converting number to dollar 10

Top