View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
northlake northlake is offline
external usenet poster
 
Posts: 1
Default Copying Data from 1 format to another

I have data in this row type of format:

Name:xxx
Address:xxx
Phone Number:xxx

With about 75 entries like this.
I need to get it into a column type of format:
Name Address Phone Number
x x
x

The name, address, phone number are all similar-they came in a form. Is
there a shortcut to moving the entries to the columns that I want them In?