Column to Row

[Guest]

I have a column of information that is currently in the following format:

Name
Address
Phone

Name
Address
Phone

And I would like to convert it to rows, such as:
Name Address Phone

Is there a method to do this?

Thank you in advance for your help.

Gale Armour

 

[Jason Morin]

Assuming your data begins in A1 and works its way down
column A, put this in B1, copy over to D1, and fill down
until you start seeing 0's:

=OFFSET($A$1,ROW()*4-6+COLUMN(),)

Now select column B to D, Edit > Copy, Edit > Paste
Special > Value, and delete col. A.

HTH
Jason
Atlanta, GA