Hi!

Try this:

Assume you want to transpose this data to a new sheet starting in cell A1:

Enter this formula in the new sheet cell A1:

=INDEX(Sheet1!$A:$A,(ROWS($1:1)-1)*3+COLUMN())

Copy across to C1 then down until you get returns of 0.

Biff

"BCLivell" wrote in message
...
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!!!