MrExcel Publishing
Your One Stop for Excel Tips & Solutions

copying a row to a column

Posted by jerry malloy on December 21, 2000 6:11 AM

Is there a way to copy the contents of an entire row into a single column?

Haven't found a way and I need an answer


Posted by cpod on December 21, 2000 6:22 AM

Check Help for the Transpose function.

Posted by cpod on December 21, 2000 6:25 AM

Actually an easier way is to copy the row go to Paste Special -> Transpose

Posted by Celia on December 21, 2000 6:28 AM

In the Help file look at :-
"Switch rows of cells to columns or columns to rows"

Also look at the TRANSPOSE worksheet function.