Data in columns not rows

[Jenn]

I have file that is names, addresses and phone numbers.
When I copy it into excel it comes out like this.
(COLUMNA)
NAME
ADDRESS
ADDRESS2
PHONE

I need it to be like this
COLUMNA COLUMNB COLUMNC COLUMND
NAME ADDRESS ADDRESS2 PHONE

Is there a way to change this without copying and pasting?

 

[Gord Dibben]

Jenn

Is the data consistently 4 rows? Or do you have varying sets?

How far down Column A do the sets extend?

If 4 rows per set try this.....

In B1 enter =INDEX($A$1:$A$3000,(ROW()-1)*4+COLUMN()-1,1)

Drag/copy across to E1 then select B1:E1 and drag/copy down untill you start
getting #REF!

The range $A$1:$A$3000 is arbitrary. Adjust to suit.

Gord Dibben Excel MVP