MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copying Data Row to a Column

Posted by Don Hileman on August 29, 2001 5:46 AM

I am trying to copy a row of values to one column. When I copy it into the column, it copies the values to adjacents columns. I just want it into one column.

Posted by Mark W. on August 29, 2001 7:13 AM

Use Paste Special... and use the Transpose option.