row to column

  • Thread starter Thread starter deb
  • Start date Start date
Yes, but instead of doing a <paste> you would move your cursor to
where you want the copied data to start (which must not overlap the
row you have just selected and <copied>), and then use Edit | Paste
Special | Transpose (check) then OK and <Esc>.

Hope this helps.

Pete
 
Select the row to copy
Copy it

Select the top cell of the column to paste
edit|paste special|check Transpose and ok

The row and the column can't overlap. So you may want to limit your copied
range to just the cells you need (like columns A:E...)
 
select the row, copy, right click where you want it, paste special, check
transpose
 
Copy the row and then right click at the starting cell in the column you want
to place the row in and select PASTE SPECIAL from the shortcut menu.

Locate the TRANSPOSE check box and click to turn on, click OK to exit to the
workbook
 
You must log in or register to reply here.

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

Excel Help to copy information from one row at a time to another sheet 1
copying one column with hidden/filtered rows to another colum 2
counting blank cells within two columns 2
How do I Copy and Paste onto Same Rows after filtering out rows. 2
Copy paste data from a column to a row 0
Copy/Paste with Hidden Rows/Columns Excel 2007 3
Copy and paste to the last row 3
MACRO PASTE CELL to COLUMN, SKIP ROWS 1

Back
Top