MrExcel Publishing
Your One Stop for Excel Tips & Solutions

i need to know ....

Posted by ditto on February 07, 2002 2:19 PM

i need to figure out how to take numbers from a column and put them into a row. i hope this makes sense.

Posted by Mark W. on February 07, 2002 2:24 PM

Been there, done that...

See 20943.html

Or use Copy/Paste Special... Values Transpose.

Posted by Greg on February 07, 2002 2:25 PM

Copy the cells.

Select the starting cells to which the new row data will start.

Click on the EDIT menu and select PASTE SPECIAL and check the TRANSPOSE box.


Posted by Dan Barsotti on February 07, 2002 2:48 PM

I usually just copy the information in the row and you can repaste it in column form. Go into paste special and you can choose "column" or "down" something like that. Hope that helps.

Posted by Donaldo Gordillo on February 07, 2002 3:18 PM

You can use paste special, Transpose.