View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Changing Columns to rows in a spreadsheet

hi.
editpastespecialtranspose

regards
FSt1

"PamelaO" wrote:

I have data that I am cutting and pasting into excel. It currently is set up
to have all the data in columns instead of rows. Is there any way to pivot
the data so that it is put into rows? For example:

Currently the data is like this:

First Name
Last Name
Email
Address
Zip


I want it like this: First Name Last Name Email Address Zip

It would be greatly appreciated any help.