How do I convert excel data from rows to columns?

G

Guest

I have data in excel that was put in wrongly. Instead of using the columns
as main sources (ie Name, PhoneNo, Address) It was put in rows. (Row 1 Name
Row 2 Address) HELP!
 
E

Earl Kiosterud

Scott,

Select the cells, Copy. Find a place (not over the original cells) to put
the transposed data, and select the upper-left cell. Paste Special -
Transpose.
 

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

counting blank cells within two columns 2
Convert rows to columns 5
How to filter rows data based on background color of individual cells 1
Transpose not working rows to columns 3
Combining data from multiple rows 2
Move rows into columns 3
convert columns to rows 6
rows and columns on worksheet 1

Top