How do I convert excel data from rows to columns?

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
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.
 
Back
Top