Data in columns not rows

  • Thread starter Thread starter Jenn
  • Start date Start date
J

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?
 
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
 
Back
Top