Data from Rows into columns

Giganews Newsgroups
Subject: Data from Rows into columns
Posted by:  BCLivell
Date: Mon, 8 May 2006

I have an excel worksheet that someone provide me.  All of the information is
in 1 column (A) with each row having the person's contact info.  The pattern
repeats for each contact.  The pattern like this

A1-Company name
A2-Name
A3-phone

There are 100 contacts in this format.  I need to seperate all of the
information so that the comany name is one column and the name is an another
column and the phone is in a third column.  I can not figure out how to do
this.  Thank you!!!

Replies