rows into columns

[steve111]

hi ,

I have a spread sheet that has names , address , phone numbers etc in rows
I would like to get them into column order if possible
is there a macro that could do this , I have attached a sample of what it is like at present

thanks
steve

[Destroy]

Looks like the only thing in rows are the phone numbers and they are always in the same spot, this correct?

[salmk2005]

you can use the concatenate function,

for example paste this code into J4 in your file =CONCATENATE(A4,B4,G4,H4)
or try this one as another model on J4 also =CONCATENATE(A4," - ",B4," - ",G4," - ",H4)