Column to Row

G

Gale Armour

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
 
J

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
 
Top