View Single Post
  #1   Report Post  
ryoung
 
Posts: n/a
Default How do I change data that has been entered in a column to a row?

I have text data (name, address, city, state, zip) that has been entered on a
spreadsheet in columns down the spread sheet (each criteria in it's own cell
vertically/in columns) and I need each of the above mentioned criteria to be
in it's own cell horizontally so that it can be imported into a database. so
in other words the name, address etc woul read from left to right across the
spreadsheet. I have Mircosfot Excel 2003. I have over 300 names and addresses
to convert. Any idea on how to make this fast and easy would be very
appreciated.