Changing Columns to rows in a spreadsheet

G

Guest

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.
 
T

Trevor Shuttleworth

Copy the cells; Paste Special Transpose to another area on the sheet (not
overlapping)

Regards

Trevor
 
P

Peo Sjoblom

Click the clipboard button on the home tab, there you should have all the
copy and paste options (it's the first button to the left)
 
G

Guest

hi,
I still stuck on 2003. I would assume that it would be on the menu bar
Edit>pastespecial>transpose. that is where is has been since xl97 but MS may
have moved it. follow trevors suggestion. it's the same as mine.

Regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Move rows into columns 3
Convert rows to columns 5
printing mailing labels when data is in rows 3
Transpose not working rows to columns 3
Convert a Word address label file to an Excel spreadsheet 2
VBA - retrieve data on last create named range from previous inserted named range 0
filtering rows across several columns 1
Consolidate multiple entries 1

Top