formating sheet

[Node321]

i have one column that has three rows of info
name
street address, City, State Zipcode
phone number

how do i make it a column an input and a row for each name? like,
Name | Street Address | City | State | ZIPcode | Phone number

thanks in advanced

 

[d.winkler]

You are just trying to move data that is in mulitiple rows and single
column, to single row and multiple columns?

Then use Copy, PasteSpecial with Transpose:

Range("A1:A3").Select
Selection.Copy
Range("A4").Select
Selection.PasteSpecial Paste:=xlAll, Operation:=xlNone,
SkipBlanks:=False, Transpose:=True

 

[Node321]

thanks
the thing is there are about 250 names
and i need it to to change from one column and three rows of info to
one row and 6 columns of info.