MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copying Data from Columns and pasting in Rows


Posted by Dominic on March 19, 2001 6:06 AM

Is there an easy way to copy data from a column ie vertically and then to paste it in Rows ie Horizontally?


Posted by Mark W. on March 19, 2001 6:33 AM

Dominic, check the Transpose option on the
Paste Special... dialog.

Posted by Dominic on March 19, 2001 6:37 AM

Thanks very Much