MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Changing Rows to Columns


Posted by Joe Garza on December 20, 2001 12:24 PM

Does anyone know how to change a row into a column...I have several rows of data that should have been made into columns. I.e., a1,b1,c1...I want to be a1,a2,a3...etc.


Posted by Juan Pablo G. on December 20, 2001 12:29 PM

Copy, Paste Special, Transpose.

Juan Pablo G.

Posted by Kevin Mac on December 20, 2001 12:29 PM

Is this "the" Joe Garza from Texas?

Posted by Joe Garza on December 20, 2001 12:30 PM

That would be me...???

Posted by Joe Garza on December 20, 2001 12:32 PM

DAAHHH...stupid question...I forgot.

Posted by Kevin Mac on December 20, 2001 12:36 PM

Re: SAY ITS NOT TRUE

""""THE JOE GARZA THAT PLAYS GUITAR IN COFFEE SHOPS IN TEXAS??

Posted by Joe Garza on December 20, 2001 12:38 PM


It actually did not work...I guess because I have a Paste Link in the rows that I want to transpose. Any ideas.

Posted by jgarza on December 20, 2001 12:39 PM

Re: SAY ITS NOT TRUE


OK...that's NOT me.

Posted by Kevin Mac on December 20, 2001 12:52 PM

Re: SAY ITS NOT TRUE


Did you get an error ? or get #REF! ? or what ? i think the problem is that you copied a range, A1:A3, and tried to copy it to A1, this will cause an error. You'll need to copy it to B1, and then (Values also), erase A1:A3, and move B1:D1 to A1:C1

Juan Pablo G. : Copy, Paste Special, Transpose. : Juan Pablo G.