Ping: Frogman or any other Excel experts

MikeVick7 · 07-23-2005, 02:05 PM

If I copy a list of numbers that are in a column, is is possible to paste them going across in a row? If so, how?

Dutch · 07-23-2005, 02:25 PM

Select Range-->Paste Special-->Transpose is what you are looking for, I think.

FrogMan · 07-23-2005, 03:33 PM

If I understand what you want to do, I'd say what Dutch said is the way to go.

That is if you have:

Code:

and you'd want to end up with something like

Code:

1	 2	 3	 4	 5

where each number would be in a different cell obviously, then yeah that'S the way to do it...

FM

MikeVick7 · 07-23-2005, 04:06 PM

Thanks guys.

Capital · 07-23-2005, 10:09 PM

That's very useful information and something that I have wanted to do in the past.
Thanks

07-23-2005, 03:33 PM	#3
FrogMan Hattrick Moderator Join Date: Jan 2003 Location: Pintendre, Qc, Canada	If I understand what you want to do, I'd say what Dutch said is the way to go. That is if you have: Code: 1 2 3 4 5 and you'd want to end up with something like Code: 1 2 3 4 5 where each number would be in a different cell obviously, then yeah that'S the way to do it... FM __________________ A Black Belt is a White Belt who refused to give up... follow my story: The real life story of a running frog... Last edited by FrogMan : 07-23-2005 at 03:34 PM.

07-23-2005, 04:06 PM	#4
MikeVick7 College Benchwarmer Join Date: Dec 2003 Location: Ron, Mexico	Thanks guys. __________________ Hattrick - Seattle Reign (224367)

07-23-2005, 02:25 PM	#2
Dutch "Dutch" Join Date: Oct 2000 Location: Tampa, FL	Select Range-->Paste Special-->Transpose is what you are looking for, I think.

07-23-2005, 10:09 PM	#5
Capital High School Varsity Join Date: Oct 2000	That's very useful information and something that I have wanted to do in the past. Thanks

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)